--
-- HGDB database dump
--

-- Dumped from database version 12.7
-- Dumped by pg_dump version 12.3

-- Started on 2023-09-18 14:09:28

/* SET application_name = securedump;
SET ROLE = sysdba;
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off; */

--
-- TOC entry 27 (class 2615 OID 131609)
-- Name: ruoyi; Type: SCHEMA; Schema: -; Owner: highgo
--

CREATE SCHEMA ruoyi;

create cast ( int as char) with INOUT as IMPLICIT;

ALTER SCHEMA ruoyi OWNER TO highgo;

--
-- TOC entry 364 (class 1255 OID 132023)
-- Name: substring_index(character varying, character varying, integer); Type: FUNCTION; Schema: ruoyi; Owner: sysdba
--

CREATE FUNCTION ruoyi.substring_index(character varying, character varying, integer) RETURNS character varying
    LANGUAGE plpgsql IMMUTABLE STRICT
    AS $_$
DECLARE
tokens varchar[];
length integer ;
indexnum integer;
BEGIN
tokens := pg_catalog.string_to_array($1, $2);
length := pg_catalog.array_upper(tokens, 1);
indexnum := length - ($3 * -1) + 1;
IF $3 >= 0 THEN
RETURN pg_catalog.array_to_string(tokens[1:$3], $2);
ELSE
RETURN pg_catalog.array_to_string(tokens[indexnum:length], $2);
END IF;
END;
$_$;

CREATE OR REPLACE FUNCTION ruoyi.FIND_IN_SET(v1 anyelement, v2 varchar)
RETURNS boolean AS
$$
    Select cast(v1 as text) = any(string_to_array(v2,','));
$$
LANGUAGE SQL;

create or replace function ruoyi.cast_boolean_to_smallint(boolean) returns smallint as
$$
select oracle.decode($1::boolean,'f'::boolean,0::smallint,'t'::boolean,1::smallint,true);
$$
language sql strict;
create cast(boolean as smallint) with function ruoyi.cast_boolean_to_smallint(boolean) as implicit;

--
-- TOC entry 345 (class 1259 OID 131872)
-- Name: seq_gen_table_table_id; Type: SEQUENCE; Schema: ruoyi; Owner: highgo
--

CREATE SEQUENCE ruoyi.seq_gen_table_table_id
    START WITH 1
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi.seq_gen_table_table_id OWNER TO highgo;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- TOC entry 320 (class 1259 OID 131634)
-- Name: gen_table; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.gen_table (
    table_id bigint DEFAULT nextval('ruoyi.seq_gen_table_table_id'::regclass) NOT NULL,
    table_name character varying(200) DEFAULT ''::character varying,
    table_comment character varying(500) DEFAULT ''::character varying,
    sub_table_name character varying(64),
    sub_table_fk_name character varying(64),
    class_name character varying(100) DEFAULT ''::character varying,
    tpl_category character varying(200) DEFAULT 'crud'::character varying,
    package_name character varying(100),
    module_name character varying(30),
    business_name character varying(30),
    function_name character varying(50),
    function_author character varying(50),
    gen_type character(1) DEFAULT '0'::bpchar,
    gen_path character varying(200) DEFAULT '/'::character varying,
    options character varying(1000),
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500)
);


ALTER TABLE ruoyi.gen_table OWNER TO highgo;

--
-- TOC entry 4277 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.table_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.table_id IS '编号';


--
-- TOC entry 4278 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.table_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.table_name IS '表名称';


--
-- TOC entry 4279 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.table_comment; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.table_comment IS '表描述';


--
-- TOC entry 4280 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.sub_table_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.sub_table_name IS '关联子表的表名';


--
-- TOC entry 4281 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.sub_table_fk_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.sub_table_fk_name IS '子表关联的外键名';


--
-- TOC entry 4282 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.class_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.class_name IS '实体类名称';


--
-- TOC entry 4283 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.tpl_category; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.tpl_category IS '使用的模板（crud单表操作 tree树表操作）';


--
-- TOC entry 4284 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.package_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.package_name IS '生成包路径';


--
-- TOC entry 4285 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.module_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.module_name IS '生成模块名';


--
-- TOC entry 4286 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.business_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.business_name IS '生成业务名';


--
-- TOC entry 4287 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.function_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.function_name IS '生成功能名';


--
-- TOC entry 4288 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.function_author; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.function_author IS '生成功能作者';


--
-- TOC entry 4289 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.gen_type; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.gen_type IS '生成代码方式（0zip压缩包 1自定义路径）';


--
-- TOC entry 4290 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.gen_path; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.gen_path IS '生成路径（不填默认项目路径）';


--
-- TOC entry 4291 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.options; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.options IS '其它生成选项';


--
-- TOC entry 4292 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.create_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.create_by IS '创建者';


--
-- TOC entry 4293 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.create_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.create_time IS '创建时间';


--
-- TOC entry 4294 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.update_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.update_by IS '更新者';


--
-- TOC entry 4295 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.update_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.update_time IS '更新时间';


--
-- TOC entry 4296 (class 0 OID 0)
-- Dependencies: 320
-- Name: COLUMN gen_table.remark; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table.remark IS '备注';


--
-- TOC entry 346 (class 1259 OID 131875)
-- Name: seq_gen_table_column_column_id; Type: SEQUENCE; Schema: ruoyi; Owner: highgo
--

CREATE SEQUENCE ruoyi.seq_gen_table_column_column_id
    START WITH 1
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi.seq_gen_table_column_column_id OWNER TO highgo;

--
-- TOC entry 322 (class 1259 OID 131654)
-- Name: gen_table_column; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.gen_table_column (
    column_id bigint DEFAULT nextval('ruoyi.seq_gen_table_column_column_id'::regclass) NOT NULL,
    table_id bigint,
    column_name character varying(200),
    column_comment character varying(500),
    column_type character varying(100),
    java_type character varying(500),
    java_field character varying(200),
    is_pk character(1),
    is_increment character(1),
    is_required character(1),
    is_insert character(1),
    is_edit character(1),
    is_list character(1),
    is_query character(1),
    query_type character varying(200) DEFAULT 'EQ'::character varying,
    html_type character varying(200),
    dict_type character varying(200) DEFAULT ''::character varying,
    sort integer,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone
);


ALTER TABLE ruoyi.gen_table_column OWNER TO highgo;

--
-- TOC entry 4297 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.column_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.column_id IS '编号';


--
-- TOC entry 4298 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.table_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.table_id IS '归属表编号';


--
-- TOC entry 4299 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.column_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.column_name IS '列名称';


--
-- TOC entry 4300 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.column_comment; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.column_comment IS '列描述';


--
-- TOC entry 4301 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.column_type; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.column_type IS '列类型';


--
-- TOC entry 4302 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.java_type; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.java_type IS 'JAVA类型';


--
-- TOC entry 4303 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.java_field; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.java_field IS 'JAVA字段名';


--
-- TOC entry 4304 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.is_pk; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.is_pk IS '是否主键（1是）';


--
-- TOC entry 4305 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.is_increment; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.is_increment IS '是否自增（1是）';


--
-- TOC entry 4306 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.is_required; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.is_required IS '是否必填（1是）';


--
-- TOC entry 4307 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.is_insert; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.is_insert IS '是否为插入字段（1是）';


--
-- TOC entry 4308 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.is_edit; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.is_edit IS '是否编辑字段（1是）';


--
-- TOC entry 4309 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.is_list; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.is_list IS '是否列表字段（1是）';


--
-- TOC entry 4310 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.is_query; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.is_query IS '是否查询字段（1是）';


--
-- TOC entry 4311 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.query_type; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.query_type IS '查询方式（等于、不等于、大于、小于、范围）';


--
-- TOC entry 4312 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.html_type; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.html_type IS '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）';


--
-- TOC entry 4313 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.dict_type; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.dict_type IS '字典类型';


--
-- TOC entry 4314 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.sort; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.sort IS '排序';


--
-- TOC entry 4315 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.create_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.create_by IS '创建者';


--
-- TOC entry 4316 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.create_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.create_time IS '创建时间';


--
-- TOC entry 4317 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.update_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.update_by IS '更新者';


--
-- TOC entry 4318 (class 0 OID 0)
-- Dependencies: 322
-- Name: COLUMN gen_table_column.update_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.gen_table_column.update_time IS '更新时间';


--
-- TOC entry 360 (class 1259 OID 132013)
-- Name: list_column; Type: VIEW; Schema: ruoyi; Owner: sysdba
--

CREATE VIEW ruoyi.list_column AS
 SELECT c.relname AS table_name,
    a.attname AS column_name,
    d.description AS column_comment,
        CASE
            WHEN (a.attnotnull AND (con.conname IS NULL)) THEN 1
            ELSE 0
        END AS is_required,
        CASE
            WHEN (con.conname IS NOT NULL) THEN 1
            ELSE 0
        END AS is_pk,
    a.attnum AS sort,
        CASE
            WHEN ("position"(pg_get_expr(ad.adbin, ad.adrelid), ((((c.relname)::text || '_'::text) || (a.attname)::text) || '_seq'::text)) > 0) THEN 1
            ELSE 0
        END AS is_increment,
    btrim(
        CASE
            WHEN ((t.typelem <> (0)::oid) AND (t.typlen = '-1'::integer)) THEN 'ARRAY'::text
            ELSE
            CASE
                WHEN (t.typtype = 'd'::"char") THEN format_type(t.typbasetype, NULL::integer)
                ELSE format_type(a.atttypid, NULL::integer)
            END
        END, '"'::text) AS column_type
   FROM (((((pg_attribute a
     JOIN (pg_class c
     JOIN pg_namespace n ON ((c.relnamespace = n.oid))) ON ((a.attrelid = c.oid)))
     LEFT JOIN pg_description d ON (((d.objoid = c.oid) AND (a.attnum = d.objsubid))))
     LEFT JOIN pg_constraint con ON (((con.conrelid = c.oid) AND (a.attnum = ANY (con.conkey)))))
     LEFT JOIN pg_attrdef ad ON (((a.attrelid = ad.adrelid) AND (a.attnum = ad.adnum))))
     LEFT JOIN pg_type t ON ((a.atttypid = t.oid)))
  WHERE ((c.relkind = ANY (ARRAY['r'::"char", 'p'::"char"])) AND (a.attnum > 0) AND (n.nspname = CURRENT_SCHEMA))
  ORDER BY c.relname, a.attnum;

--
-- TOC entry 361 (class 1259 OID 132018)
-- Name: list_table; Type: VIEW; Schema: ruoyi; Owner: sysdba
--

CREATE VIEW ruoyi.list_table AS
 SELECT c.relname AS table_name,
    obj_description(c.oid) AS table_comment,
    CURRENT_TIMESTAMP AS create_time,
    CURRENT_TIMESTAMP AS update_time
   FROM (pg_class c
     LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace)))
  WHERE ((c.relkind = ANY (ARRAY['r'::"char", 'p'::"char"])) AND (c.relname !~~ 'spatial_%'::text) AND (n.nspname = CURRENT_SCHEMA) AND (n.nspname <> ''::name));

--
-- TOC entry 317 (class 1259 OID 131619)
-- Name: qrtz_blob_triggers; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.qrtz_blob_triggers (
    sched_name character varying(120) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    blob_data bytea
);


ALTER TABLE ruoyi.qrtz_blob_triggers OWNER TO highgo;

--
-- TOC entry 4319 (class 0 OID 0)
-- Dependencies: 317
-- Name: COLUMN qrtz_blob_triggers.sched_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_blob_triggers.sched_name IS '调度名称';


--
-- TOC entry 4320 (class 0 OID 0)
-- Dependencies: 317
-- Name: COLUMN qrtz_blob_triggers.trigger_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_blob_triggers.trigger_name IS 'qrtz_triggers表trigger_name的外键';


--
-- TOC entry 4321 (class 0 OID 0)
-- Dependencies: 317
-- Name: COLUMN qrtz_blob_triggers.trigger_group; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_blob_triggers.trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- TOC entry 4322 (class 0 OID 0)
-- Dependencies: 317
-- Name: COLUMN qrtz_blob_triggers.blob_data; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_blob_triggers.blob_data IS '存放持久化Trigger对象';


--
-- TOC entry 315 (class 1259 OID 131610)
-- Name: qrtz_calendars; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.qrtz_calendars (
    sched_name character varying(120) NOT NULL,
    calendar_name character varying(200) NOT NULL,
    calendar bytea NOT NULL
);


ALTER TABLE ruoyi.qrtz_calendars OWNER TO highgo;

--
-- TOC entry 4323 (class 0 OID 0)
-- Dependencies: 315
-- Name: COLUMN qrtz_calendars.sched_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_calendars.sched_name IS '调度名称';


--
-- TOC entry 4324 (class 0 OID 0)
-- Dependencies: 315
-- Name: COLUMN qrtz_calendars.calendar_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_calendars.calendar_name IS '日历名称';


--
-- TOC entry 4325 (class 0 OID 0)
-- Dependencies: 315
-- Name: COLUMN qrtz_calendars.calendar; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_calendars.calendar IS '存放持久化calendar对象';


--
-- TOC entry 324 (class 1259 OID 131667)
-- Name: qrtz_cron_triggers; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.qrtz_cron_triggers (
    sched_name character varying(120) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    cron_expression character varying(200) NOT NULL,
    time_zone_id character varying(80)
);


ALTER TABLE ruoyi.qrtz_cron_triggers OWNER TO highgo;

--
-- TOC entry 4326 (class 0 OID 0)
-- Dependencies: 324
-- Name: COLUMN qrtz_cron_triggers.sched_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_cron_triggers.sched_name IS '调度名称';


--
-- TOC entry 4327 (class 0 OID 0)
-- Dependencies: 324
-- Name: COLUMN qrtz_cron_triggers.trigger_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_cron_triggers.trigger_name IS 'qrtz_triggers表trigger_name的外键';


--
-- TOC entry 4328 (class 0 OID 0)
-- Dependencies: 324
-- Name: COLUMN qrtz_cron_triggers.trigger_group; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_cron_triggers.trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- TOC entry 4329 (class 0 OID 0)
-- Dependencies: 324
-- Name: COLUMN qrtz_cron_triggers.cron_expression; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_cron_triggers.cron_expression IS 'cron表达式';


--
-- TOC entry 4330 (class 0 OID 0)
-- Dependencies: 324
-- Name: COLUMN qrtz_cron_triggers.time_zone_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_cron_triggers.time_zone_id IS '时区';


--
-- TOC entry 318 (class 1259 OID 131625)
-- Name: qrtz_fired_triggers; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.qrtz_fired_triggers (
    sched_name character varying(120) NOT NULL,
    entry_id character varying(95) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    instance_name character varying(200) NOT NULL,
    fired_time bigint NOT NULL,
    sched_time bigint NOT NULL,
    priority integer NOT NULL,
    state character varying(16) NOT NULL,
    job_name character varying(200),
    job_group character varying(200),
    is_nonconcurrent character varying(1),
    requests_recovery character varying(1)
);


ALTER TABLE ruoyi.qrtz_fired_triggers OWNER TO highgo;

--
-- TOC entry 4331 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN qrtz_fired_triggers.sched_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_fired_triggers.sched_name IS '调度名称';


--
-- TOC entry 4332 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN qrtz_fired_triggers.entry_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_fired_triggers.entry_id IS '调度器实例id';


--
-- TOC entry 4333 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN qrtz_fired_triggers.trigger_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_fired_triggers.trigger_name IS 'qrtz_triggers表trigger_name的外键';


--
-- TOC entry 4334 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN qrtz_fired_triggers.trigger_group; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_fired_triggers.trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- TOC entry 4335 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN qrtz_fired_triggers.instance_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_fired_triggers.instance_name IS '调度器实例名';


--
-- TOC entry 4336 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN qrtz_fired_triggers.fired_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_fired_triggers.fired_time IS '触发的时间';


--
-- TOC entry 4337 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN qrtz_fired_triggers.sched_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_fired_triggers.sched_time IS '定时器制定的时间';


--
-- TOC entry 4338 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN qrtz_fired_triggers.priority; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_fired_triggers.priority IS '优先级';


--
-- TOC entry 4339 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN qrtz_fired_triggers.state; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_fired_triggers.state IS '状态';


--
-- TOC entry 4340 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN qrtz_fired_triggers.job_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_fired_triggers.job_name IS '任务名称';


--
-- TOC entry 4341 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN qrtz_fired_triggers.job_group; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_fired_triggers.job_group IS '任务组名';


--
-- TOC entry 4342 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN qrtz_fired_triggers.is_nonconcurrent; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_fired_triggers.is_nonconcurrent IS '是否并发';


--
-- TOC entry 4343 (class 0 OID 0)
-- Dependencies: 318
-- Name: COLUMN qrtz_fired_triggers.requests_recovery; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_fired_triggers.requests_recovery IS '是否接受恢复执行';


--
-- TOC entry 321 (class 1259 OID 131648)
-- Name: qrtz_job_details; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.qrtz_job_details (
    sched_name character varying(120) NOT NULL,
    job_name character varying(200) NOT NULL,
    job_group character varying(200) NOT NULL,
    description character varying(250),
    job_class_name character varying(250) NOT NULL,
    is_durable character varying(1) NOT NULL,
    is_nonconcurrent character varying(1) NOT NULL,
    is_update_data character varying(1) NOT NULL,
    requests_recovery character varying(1) NOT NULL,
    job_data bytea
);


ALTER TABLE ruoyi.qrtz_job_details OWNER TO highgo;

--
-- TOC entry 4344 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN qrtz_job_details.sched_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_job_details.sched_name IS '调度名称';


--
-- TOC entry 4345 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN qrtz_job_details.job_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_job_details.job_name IS '任务名称';


--
-- TOC entry 4346 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN qrtz_job_details.job_group; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_job_details.job_group IS '任务组名';


--
-- TOC entry 4347 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN qrtz_job_details.description; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_job_details.description IS '相关介绍';


--
-- TOC entry 4348 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN qrtz_job_details.job_class_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_job_details.job_class_name IS '执行任务类名称';


--
-- TOC entry 4349 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN qrtz_job_details.is_durable; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_job_details.is_durable IS '是否持久化';


--
-- TOC entry 4350 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN qrtz_job_details.is_nonconcurrent; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_job_details.is_nonconcurrent IS '是否并发';


--
-- TOC entry 4351 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN qrtz_job_details.is_update_data; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_job_details.is_update_data IS '是否更新数据';


--
-- TOC entry 4352 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN qrtz_job_details.requests_recovery; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_job_details.requests_recovery IS '是否接受恢复执行';


--
-- TOC entry 4353 (class 0 OID 0)
-- Dependencies: 321
-- Name: COLUMN qrtz_job_details.job_data; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_job_details.job_data IS '存放持久化job对象';


--
-- TOC entry 316 (class 1259 OID 131616)
-- Name: qrtz_locks; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.qrtz_locks (
    sched_name character varying(120) NOT NULL,
    lock_name character varying(40) NOT NULL
);


ALTER TABLE ruoyi.qrtz_locks OWNER TO highgo;

--
-- TOC entry 4354 (class 0 OID 0)
-- Dependencies: 316
-- Name: COLUMN qrtz_locks.sched_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_locks.sched_name IS '调度名称';


--
-- TOC entry 4355 (class 0 OID 0)
-- Dependencies: 316
-- Name: COLUMN qrtz_locks.lock_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_locks.lock_name IS '悲观锁名称';


--
-- TOC entry 319 (class 1259 OID 131631)
-- Name: qrtz_paused_trigger_grps; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.qrtz_paused_trigger_grps (
    sched_name character varying(120) NOT NULL,
    trigger_group character varying(200) NOT NULL
);


ALTER TABLE ruoyi.qrtz_paused_trigger_grps OWNER TO highgo;

--
-- TOC entry 4356 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN qrtz_paused_trigger_grps.sched_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_paused_trigger_grps.sched_name IS '调度名称';


--
-- TOC entry 4357 (class 0 OID 0)
-- Dependencies: 319
-- Name: COLUMN qrtz_paused_trigger_grps.trigger_group; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_paused_trigger_grps.trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- TOC entry 323 (class 1259 OID 131664)
-- Name: qrtz_scheduler_state; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.qrtz_scheduler_state (
    sched_name character varying(120) NOT NULL,
    instance_name character varying(200) NOT NULL,
    last_checkin_time bigint NOT NULL,
    checkin_interval bigint NOT NULL
);


ALTER TABLE ruoyi.qrtz_scheduler_state OWNER TO highgo;

--
-- TOC entry 4358 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN qrtz_scheduler_state.sched_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_scheduler_state.sched_name IS '调度名称';


--
-- TOC entry 4359 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN qrtz_scheduler_state.instance_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_scheduler_state.instance_name IS '实例名称';


--
-- TOC entry 4360 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN qrtz_scheduler_state.last_checkin_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_scheduler_state.last_checkin_time IS '上次检查时间';


--
-- TOC entry 4361 (class 0 OID 0)
-- Dependencies: 323
-- Name: COLUMN qrtz_scheduler_state.checkin_interval; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_scheduler_state.checkin_interval IS '检查间隔时间';


--
-- TOC entry 329 (class 1259 OID 131708)
-- Name: qrtz_simple_triggers; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.qrtz_simple_triggers (
    sched_name character varying(120) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    repeat_count bigint NOT NULL,
    repeat_interval bigint NOT NULL,
    times_triggered bigint NOT NULL
);


ALTER TABLE ruoyi.qrtz_simple_triggers OWNER TO highgo;

--
-- TOC entry 4362 (class 0 OID 0)
-- Dependencies: 329
-- Name: COLUMN qrtz_simple_triggers.sched_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simple_triggers.sched_name IS '调度名称';


--
-- TOC entry 4363 (class 0 OID 0)
-- Dependencies: 329
-- Name: COLUMN qrtz_simple_triggers.trigger_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simple_triggers.trigger_name IS 'qrtz_triggers表trigger_name的外键';


--
-- TOC entry 4364 (class 0 OID 0)
-- Dependencies: 329
-- Name: COLUMN qrtz_simple_triggers.trigger_group; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simple_triggers.trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- TOC entry 4365 (class 0 OID 0)
-- Dependencies: 329
-- Name: COLUMN qrtz_simple_triggers.repeat_count; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simple_triggers.repeat_count IS '重复的次数统计';


--
-- TOC entry 4366 (class 0 OID 0)
-- Dependencies: 329
-- Name: COLUMN qrtz_simple_triggers.repeat_interval; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simple_triggers.repeat_interval IS '重复的间隔时间';


--
-- TOC entry 4367 (class 0 OID 0)
-- Dependencies: 329
-- Name: COLUMN qrtz_simple_triggers.times_triggered; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simple_triggers.times_triggered IS '已经触发的次数';


--
-- TOC entry 327 (class 1259 OID 131680)
-- Name: qrtz_simprop_triggers; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.qrtz_simprop_triggers (
    sched_name character varying(120) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    str_prop_1 character varying(512),
    str_prop_2 character varying(512),
    str_prop_3 character varying(512),
    int_prop_1 integer,
    int_prop_2 integer,
    long_prop_1 bigint,
    long_prop_2 bigint,
    dec_prop_1 numeric(13,4),
    dec_prop_2 numeric(13,4),
    bool_prop_1 character varying(1),
    bool_prop_2 character varying(1)
);


ALTER TABLE ruoyi.qrtz_simprop_triggers OWNER TO highgo;

--
-- TOC entry 4368 (class 0 OID 0)
-- Dependencies: 327
-- Name: COLUMN qrtz_simprop_triggers.sched_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simprop_triggers.sched_name IS '调度名称';


--
-- TOC entry 4369 (class 0 OID 0)
-- Dependencies: 327
-- Name: COLUMN qrtz_simprop_triggers.trigger_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simprop_triggers.trigger_name IS 'qrtz_triggers表trigger_name的外键';


--
-- TOC entry 4370 (class 0 OID 0)
-- Dependencies: 327
-- Name: COLUMN qrtz_simprop_triggers.trigger_group; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simprop_triggers.trigger_group IS 'qrtz_triggers表trigger_group的外键';


--
-- TOC entry 4371 (class 0 OID 0)
-- Dependencies: 327
-- Name: COLUMN qrtz_simprop_triggers.str_prop_1; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simprop_triggers.str_prop_1 IS 'String类型的trigger的第一个参数';


--
-- TOC entry 4372 (class 0 OID 0)
-- Dependencies: 327
-- Name: COLUMN qrtz_simprop_triggers.str_prop_2; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simprop_triggers.str_prop_2 IS 'String类型的trigger的第二个参数';


--
-- TOC entry 4373 (class 0 OID 0)
-- Dependencies: 327
-- Name: COLUMN qrtz_simprop_triggers.str_prop_3; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simprop_triggers.str_prop_3 IS 'String类型的trigger的第三个参数';


--
-- TOC entry 4374 (class 0 OID 0)
-- Dependencies: 327
-- Name: COLUMN qrtz_simprop_triggers.int_prop_1; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simprop_triggers.int_prop_1 IS 'int类型的trigger的第一个参数';


--
-- TOC entry 4375 (class 0 OID 0)
-- Dependencies: 327
-- Name: COLUMN qrtz_simprop_triggers.int_prop_2; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simprop_triggers.int_prop_2 IS 'int类型的trigger的第二个参数';


--
-- TOC entry 4376 (class 0 OID 0)
-- Dependencies: 327
-- Name: COLUMN qrtz_simprop_triggers.long_prop_1; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simprop_triggers.long_prop_1 IS 'long类型的trigger的第一个参数';


--
-- TOC entry 4377 (class 0 OID 0)
-- Dependencies: 327
-- Name: COLUMN qrtz_simprop_triggers.long_prop_2; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simprop_triggers.long_prop_2 IS 'long类型的trigger的第二个参数';


--
-- TOC entry 4378 (class 0 OID 0)
-- Dependencies: 327
-- Name: COLUMN qrtz_simprop_triggers.dec_prop_1; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simprop_triggers.dec_prop_1 IS 'decimal类型的trigger的第一个参数';


--
-- TOC entry 4379 (class 0 OID 0)
-- Dependencies: 327
-- Name: COLUMN qrtz_simprop_triggers.dec_prop_2; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simprop_triggers.dec_prop_2 IS 'decimal类型的trigger的第二个参数';


--
-- TOC entry 4380 (class 0 OID 0)
-- Dependencies: 327
-- Name: COLUMN qrtz_simprop_triggers.bool_prop_1; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simprop_triggers.bool_prop_1 IS 'Boolean类型的trigger的第一个参数';


--
-- TOC entry 4381 (class 0 OID 0)
-- Dependencies: 327
-- Name: COLUMN qrtz_simprop_triggers.bool_prop_2; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_simprop_triggers.bool_prop_2 IS 'Boolean类型的trigger的第二个参数';


--
-- TOC entry 325 (class 1259 OID 131673)
-- Name: qrtz_triggers; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.qrtz_triggers (
    sched_name character varying(120) NOT NULL,
    trigger_name character varying(200) NOT NULL,
    trigger_group character varying(200) NOT NULL,
    job_name character varying(200) NOT NULL,
    job_group character varying(200) NOT NULL,
    description character varying(250),
    next_fire_time bigint,
    prev_fire_time bigint,
    priority integer,
    trigger_state character varying(16) NOT NULL,
    trigger_type character varying(8) NOT NULL,
    start_time bigint NOT NULL,
    end_time bigint,
    calendar_name character varying(200),
    misfire_instr smallint,
    job_data bytea
);


ALTER TABLE ruoyi.qrtz_triggers OWNER TO highgo;

--
-- TOC entry 4382 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN qrtz_triggers.sched_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_triggers.sched_name IS '调度名称';


--
-- TOC entry 4383 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN qrtz_triggers.trigger_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_triggers.trigger_name IS '触发器的名字';


--
-- TOC entry 4384 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN qrtz_triggers.trigger_group; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_triggers.trigger_group IS '触发器所属组的名字';


--
-- TOC entry 4385 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN qrtz_triggers.job_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_triggers.job_name IS 'qrtz_job_details表job_name的外键';


--
-- TOC entry 4386 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN qrtz_triggers.job_group; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_triggers.job_group IS 'qrtz_job_details表job_group的外键';


--
-- TOC entry 4387 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN qrtz_triggers.description; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_triggers.description IS '相关介绍';


--
-- TOC entry 4388 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN qrtz_triggers.next_fire_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_triggers.next_fire_time IS '上一次触发时间（毫秒）';


--
-- TOC entry 4389 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN qrtz_triggers.prev_fire_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_triggers.prev_fire_time IS '下一次触发时间（默认为-1表示不触发）';


--
-- TOC entry 4390 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN qrtz_triggers.priority; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_triggers.priority IS '优先级';


--
-- TOC entry 4391 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN qrtz_triggers.trigger_state; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_triggers.trigger_state IS '触发器状态';


--
-- TOC entry 4392 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN qrtz_triggers.trigger_type; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_triggers.trigger_type IS '触发器的类型';


--
-- TOC entry 4393 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN qrtz_triggers.start_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_triggers.start_time IS '开始时间';


--
-- TOC entry 4394 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN qrtz_triggers.end_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_triggers.end_time IS '结束时间';


--
-- TOC entry 4395 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN qrtz_triggers.calendar_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_triggers.calendar_name IS '日程表名称';


--
-- TOC entry 4396 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN qrtz_triggers.misfire_instr; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_triggers.misfire_instr IS '补偿执行的策略';


--
-- TOC entry 4397 (class 0 OID 0)
-- Dependencies: 325
-- Name: COLUMN qrtz_triggers.job_data; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.qrtz_triggers.job_data IS '存放持久化job对象';


--
-- TOC entry 349 (class 1259 OID 131900)
-- Name: seq_sys_config_config_id; Type: SEQUENCE; Schema: ruoyi; Owner: highgo
--

CREATE SEQUENCE ruoyi.seq_sys_config_config_id
    START WITH 7
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi.seq_sys_config_config_id OWNER TO highgo;

--
-- TOC entry 347 (class 1259 OID 131890)
-- Name: seq_sys_dept_dept_id; Type: SEQUENCE; Schema: ruoyi; Owner: highgo
--

CREATE SEQUENCE ruoyi.seq_sys_dept_dept_id
    START WITH 110
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi.seq_sys_dept_dept_id OWNER TO highgo;

--
-- TOC entry 348 (class 1259 OID 131896)
-- Name: seq_sys_dict_data_dict_code; Type: SEQUENCE; Schema: ruoyi; Owner: highgo
--

CREATE SEQUENCE ruoyi.seq_sys_dict_data_dict_code
    START WITH 30
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi.seq_sys_dict_data_dict_code OWNER TO highgo;

--
-- TOC entry 352 (class 1259 OID 131912)
-- Name: seq_sys_dict_type_dict_id; Type: SEQUENCE; Schema: ruoyi; Owner: highgo
--

CREATE SEQUENCE ruoyi.seq_sys_dict_type_dict_id
    START WITH 11
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi.seq_sys_dict_type_dict_id OWNER TO highgo;

--
-- TOC entry 350 (class 1259 OID 131907)
-- Name: seq_sys_job_job_id; Type: SEQUENCE; Schema: ruoyi; Owner: highgo
--

CREATE SEQUENCE ruoyi.seq_sys_job_job_id
    START WITH 4
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi.seq_sys_job_job_id OWNER TO highgo;

--
-- TOC entry 351 (class 1259 OID 131911)
-- Name: seq_sys_job_log_job_log_id; Type: SEQUENCE; Schema: ruoyi; Owner: highgo
--

CREATE SEQUENCE ruoyi.seq_sys_job_log_job_log_id
    START WITH 1
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi.seq_sys_job_log_job_log_id OWNER TO highgo;

--
-- TOC entry 353 (class 1259 OID 131926)
-- Name: seq_sys_logininfor_info_id; Type: SEQUENCE; Schema: ruoyi; Owner: highgo
--

CREATE SEQUENCE ruoyi.seq_sys_logininfor_info_id
    START WITH 1
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi.seq_sys_logininfor_info_id OWNER TO highgo;

--
-- TOC entry 357 (class 1259 OID 131935)
-- Name: seq_sys_menu_menu_id; Type: SEQUENCE; Schema: ruoyi; Owner: highgo
--

CREATE SEQUENCE ruoyi.seq_sys_menu_menu_id
    START WITH 1061
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi.seq_sys_menu_menu_id OWNER TO highgo;

--
-- TOC entry 355 (class 1259 OID 131932)
-- Name: seq_sys_notice_notice_id; Type: SEQUENCE; Schema: ruoyi; Owner: highgo
--

CREATE SEQUENCE ruoyi.seq_sys_notice_notice_id
    START WITH 3
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi.seq_sys_notice_notice_id OWNER TO highgo;

--
-- TOC entry 354 (class 1259 OID 131928)
-- Name: seq_sys_oper_log_oper_id; Type: SEQUENCE; Schema: ruoyi; Owner: highgo
--

CREATE SEQUENCE ruoyi.seq_sys_oper_log_oper_id
    START WITH 1
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi.seq_sys_oper_log_oper_id OWNER TO highgo;

--
-- TOC entry 358 (class 1259 OID 131943)
-- Name: seq_sys_post_post_id; Type: SEQUENCE; Schema: ruoyi; Owner: highgo
--

CREATE SEQUENCE ruoyi.seq_sys_post_post_id
    START WITH 5
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi.seq_sys_post_post_id OWNER TO highgo;

--
-- TOC entry 356 (class 1259 OID 131934)
-- Name: seq_sys_role_role_id; Type: SEQUENCE; Schema: ruoyi; Owner: highgo
--

CREATE SEQUENCE ruoyi.seq_sys_role_role_id
    START WITH 3
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi.seq_sys_role_role_id OWNER TO highgo;

--
-- TOC entry 359 (class 1259 OID 131962)
-- Name: seq_sys_user_user_id; Type: SEQUENCE; Schema: ruoyi; Owner: highgo
--

CREATE SEQUENCE ruoyi.seq_sys_user_user_id
    START WITH 3
    INCREMENT BY 1
    MINVALUE -9223372036854775807
    NO MAXVALUE
    CACHE 1
    CYCLE;


ALTER TABLE ruoyi.seq_sys_user_user_id OWNER TO highgo;

--
-- TOC entry 326 (class 1259 OID 131679)
-- Name: sys_config; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_config (
    config_id integer DEFAULT nextval('ruoyi.seq_sys_config_config_id'::regclass) NOT NULL,
    config_name character varying(100) DEFAULT ''::character varying,
    config_key character varying(100) DEFAULT ''::character varying,
    config_value character varying(500) DEFAULT ''::character varying,
    config_type character(1) DEFAULT 'N'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500)
);


ALTER TABLE ruoyi.sys_config OWNER TO highgo;

--
-- TOC entry 4398 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_config.config_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_config.config_id IS '参数主键';


--
-- TOC entry 4399 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_config.config_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_config.config_name IS '参数名称';


--
-- TOC entry 4400 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_config.config_key; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_config.config_key IS '参数键名';


--
-- TOC entry 4401 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_config.config_value; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_config.config_value IS '参数键值';


--
-- TOC entry 4402 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_config.config_type; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_config.config_type IS '系统内置（Y是 N否）';


--
-- TOC entry 4403 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_config.create_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_config.create_by IS '创建者';


--
-- TOC entry 4404 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_config.create_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_config.create_time IS '创建时间';


--
-- TOC entry 4405 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_config.update_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_config.update_by IS '更新者';


--
-- TOC entry 4406 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_config.update_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_config.update_time IS '更新时间';


--
-- TOC entry 4407 (class 0 OID 0)
-- Dependencies: 326
-- Name: COLUMN sys_config.remark; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_config.remark IS '备注';


--
-- TOC entry 328 (class 1259 OID 131697)
-- Name: sys_dept; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_dept (
    dept_id bigint DEFAULT nextval('ruoyi.seq_sys_dept_dept_id'::regclass) NOT NULL,
    parent_id bigint DEFAULT '0'::bigint,
    ancestors character varying(50) DEFAULT ''::character varying,
    dept_name character varying(30) DEFAULT ''::character varying,
    order_num integer DEFAULT 0,
    leader character varying(20),
    phone character varying(11),
    email character varying(50),
    status character(1) DEFAULT '0'::bpchar,
    del_flag character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone
);


ALTER TABLE ruoyi.sys_dept OWNER TO highgo;

--
-- TOC entry 4408 (class 0 OID 0)
-- Dependencies: 328
-- Name: COLUMN sys_dept.dept_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dept.dept_id IS '部门id';


--
-- TOC entry 4409 (class 0 OID 0)
-- Dependencies: 328
-- Name: COLUMN sys_dept.parent_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dept.parent_id IS '父部门id';


--
-- TOC entry 4410 (class 0 OID 0)
-- Dependencies: 328
-- Name: COLUMN sys_dept.ancestors; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dept.ancestors IS '祖级列表';


--
-- TOC entry 4411 (class 0 OID 0)
-- Dependencies: 328
-- Name: COLUMN sys_dept.dept_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dept.dept_name IS '部门名称';


--
-- TOC entry 4412 (class 0 OID 0)
-- Dependencies: 328
-- Name: COLUMN sys_dept.order_num; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dept.order_num IS '显示顺序';


--
-- TOC entry 4413 (class 0 OID 0)
-- Dependencies: 328
-- Name: COLUMN sys_dept.leader; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dept.leader IS '负责人';


--
-- TOC entry 4414 (class 0 OID 0)
-- Dependencies: 328
-- Name: COLUMN sys_dept.phone; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dept.phone IS '联系电话';


--
-- TOC entry 4415 (class 0 OID 0)
-- Dependencies: 328
-- Name: COLUMN sys_dept.email; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dept.email IS '邮箱';


--
-- TOC entry 4416 (class 0 OID 0)
-- Dependencies: 328
-- Name: COLUMN sys_dept.status; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dept.status IS '部门状态（0正常 1停用）';


--
-- TOC entry 4417 (class 0 OID 0)
-- Dependencies: 328
-- Name: COLUMN sys_dept.del_flag; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dept.del_flag IS '删除标志（0代表存在 2代表删除）';


--
-- TOC entry 4418 (class 0 OID 0)
-- Dependencies: 328
-- Name: COLUMN sys_dept.create_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dept.create_by IS '创建者';


--
-- TOC entry 4419 (class 0 OID 0)
-- Dependencies: 328
-- Name: COLUMN sys_dept.create_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dept.create_time IS '创建时间';


--
-- TOC entry 4420 (class 0 OID 0)
-- Dependencies: 328
-- Name: COLUMN sys_dept.update_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dept.update_by IS '更新者';


--
-- TOC entry 4421 (class 0 OID 0)
-- Dependencies: 328
-- Name: COLUMN sys_dept.update_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dept.update_time IS '更新时间';


--
-- TOC entry 330 (class 1259 OID 131714)
-- Name: sys_dict_data; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_dict_data (
    dict_code bigint DEFAULT nextval('ruoyi.seq_sys_dict_data_dict_code'::regclass) NOT NULL,
    dict_sort integer DEFAULT 0,
    dict_label character varying(100) DEFAULT ''::character varying,
    dict_value character varying(100) DEFAULT ''::character varying,
    dict_type character varying(100) DEFAULT ''::character varying,
    css_class character varying(100),
    list_class character varying(100),
    is_default character(1) DEFAULT 'N'::bpchar,
    status character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500)
);


ALTER TABLE ruoyi.sys_dict_data OWNER TO highgo;

--
-- TOC entry 4422 (class 0 OID 0)
-- Dependencies: 330
-- Name: COLUMN sys_dict_data.dict_code; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_data.dict_code IS '字典编码';


--
-- TOC entry 4423 (class 0 OID 0)
-- Dependencies: 330
-- Name: COLUMN sys_dict_data.dict_sort; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_data.dict_sort IS '字典排序';


--
-- TOC entry 4424 (class 0 OID 0)
-- Dependencies: 330
-- Name: COLUMN sys_dict_data.dict_label; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_data.dict_label IS '字典标签';


--
-- TOC entry 4425 (class 0 OID 0)
-- Dependencies: 330
-- Name: COLUMN sys_dict_data.dict_value; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_data.dict_value IS '字典键值';


--
-- TOC entry 4426 (class 0 OID 0)
-- Dependencies: 330
-- Name: COLUMN sys_dict_data.dict_type; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_data.dict_type IS '字典类型';


--
-- TOC entry 4427 (class 0 OID 0)
-- Dependencies: 330
-- Name: COLUMN sys_dict_data.css_class; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_data.css_class IS '样式属性（其他样式扩展）';


--
-- TOC entry 4428 (class 0 OID 0)
-- Dependencies: 330
-- Name: COLUMN sys_dict_data.list_class; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_data.list_class IS '表格回显样式';


--
-- TOC entry 4429 (class 0 OID 0)
-- Dependencies: 330
-- Name: COLUMN sys_dict_data.is_default; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_data.is_default IS '是否默认（Y是 N否）';


--
-- TOC entry 4430 (class 0 OID 0)
-- Dependencies: 330
-- Name: COLUMN sys_dict_data.status; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_data.status IS '状态（0正常 1停用）';


--
-- TOC entry 4431 (class 0 OID 0)
-- Dependencies: 330
-- Name: COLUMN sys_dict_data.create_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_data.create_by IS '创建者';


--
-- TOC entry 4432 (class 0 OID 0)
-- Dependencies: 330
-- Name: COLUMN sys_dict_data.create_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_data.create_time IS '创建时间';


--
-- TOC entry 4433 (class 0 OID 0)
-- Dependencies: 330
-- Name: COLUMN sys_dict_data.update_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_data.update_by IS '更新者';


--
-- TOC entry 4434 (class 0 OID 0)
-- Dependencies: 330
-- Name: COLUMN sys_dict_data.update_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_data.update_time IS '更新时间';


--
-- TOC entry 4435 (class 0 OID 0)
-- Dependencies: 330
-- Name: COLUMN sys_dict_data.remark; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_data.remark IS '备注';


--
-- TOC entry 332 (class 1259 OID 131716)
-- Name: sys_dict_type; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_dict_type (
    dict_id bigint DEFAULT nextval('ruoyi.seq_sys_dict_type_dict_id'::regclass) NOT NULL,
    dict_name character varying(100) DEFAULT ''::character varying,
    dict_type character varying(100) DEFAULT ''::character varying,
    status character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500)
);


ALTER TABLE ruoyi.sys_dict_type OWNER TO highgo;

--
-- TOC entry 4436 (class 0 OID 0)
-- Dependencies: 332
-- Name: COLUMN sys_dict_type.dict_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_type.dict_id IS '字典主键';


--
-- TOC entry 4437 (class 0 OID 0)
-- Dependencies: 332
-- Name: COLUMN sys_dict_type.dict_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_type.dict_name IS '字典名称';


--
-- TOC entry 4438 (class 0 OID 0)
-- Dependencies: 332
-- Name: COLUMN sys_dict_type.dict_type; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_type.dict_type IS '字典类型';


--
-- TOC entry 4439 (class 0 OID 0)
-- Dependencies: 332
-- Name: COLUMN sys_dict_type.status; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_type.status IS '状态（0正常 1停用）';


--
-- TOC entry 4440 (class 0 OID 0)
-- Dependencies: 332
-- Name: COLUMN sys_dict_type.create_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_type.create_by IS '创建者';


--
-- TOC entry 4441 (class 0 OID 0)
-- Dependencies: 332
-- Name: COLUMN sys_dict_type.create_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_type.create_time IS '创建时间';


--
-- TOC entry 4442 (class 0 OID 0)
-- Dependencies: 332
-- Name: COLUMN sys_dict_type.update_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_type.update_by IS '更新者';


--
-- TOC entry 4443 (class 0 OID 0)
-- Dependencies: 332
-- Name: COLUMN sys_dict_type.update_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_type.update_time IS '更新时间';


--
-- TOC entry 4444 (class 0 OID 0)
-- Dependencies: 332
-- Name: COLUMN sys_dict_type.remark; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_dict_type.remark IS '备注';


--
-- TOC entry 331 (class 1259 OID 131715)
-- Name: sys_job; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_job (
    job_id bigint DEFAULT nextval('ruoyi.seq_sys_job_job_id'::regclass) NOT NULL,
    job_name character varying(64) DEFAULT ''::character varying NOT NULL,
    job_group character varying(64) DEFAULT 'DEFAULT'::character varying NOT NULL,
    invoke_target character varying(500) NOT NULL,
    cron_expression character varying(255) DEFAULT ''::character varying,
    misfire_policy character varying(20) DEFAULT '3'::character varying,
    concurrent character(1) DEFAULT '1'::bpchar,
    status character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500) DEFAULT ''::character varying
);


ALTER TABLE ruoyi.sys_job OWNER TO highgo;

--
-- TOC entry 4445 (class 0 OID 0)
-- Dependencies: 331
-- Name: COLUMN sys_job.job_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job.job_id IS '任务ID';


--
-- TOC entry 4446 (class 0 OID 0)
-- Dependencies: 331
-- Name: COLUMN sys_job.job_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job.job_name IS '任务名称';


--
-- TOC entry 4447 (class 0 OID 0)
-- Dependencies: 331
-- Name: COLUMN sys_job.job_group; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job.job_group IS '任务组名';


--
-- TOC entry 4448 (class 0 OID 0)
-- Dependencies: 331
-- Name: COLUMN sys_job.invoke_target; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job.invoke_target IS '调用目标字符串';


--
-- TOC entry 4449 (class 0 OID 0)
-- Dependencies: 331
-- Name: COLUMN sys_job.cron_expression; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job.cron_expression IS 'cron执行表达式';


--
-- TOC entry 4450 (class 0 OID 0)
-- Dependencies: 331
-- Name: COLUMN sys_job.misfire_policy; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job.misfire_policy IS '计划执行错误策略（1立即执行 2执行一次 3放弃执行）';


--
-- TOC entry 4451 (class 0 OID 0)
-- Dependencies: 331
-- Name: COLUMN sys_job.concurrent; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job.concurrent IS '是否并发执行（0允许 1禁止）';


--
-- TOC entry 4452 (class 0 OID 0)
-- Dependencies: 331
-- Name: COLUMN sys_job.status; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job.status IS '状态（0正常 1暂停）';


--
-- TOC entry 4453 (class 0 OID 0)
-- Dependencies: 331
-- Name: COLUMN sys_job.create_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job.create_by IS '创建者';


--
-- TOC entry 4454 (class 0 OID 0)
-- Dependencies: 331
-- Name: COLUMN sys_job.create_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job.create_time IS '创建时间';


--
-- TOC entry 4455 (class 0 OID 0)
-- Dependencies: 331
-- Name: COLUMN sys_job.update_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job.update_by IS '更新者';


--
-- TOC entry 4456 (class 0 OID 0)
-- Dependencies: 331
-- Name: COLUMN sys_job.update_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job.update_time IS '更新时间';


--
-- TOC entry 4457 (class 0 OID 0)
-- Dependencies: 331
-- Name: COLUMN sys_job.remark; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job.remark IS '备注信息';


--
-- TOC entry 333 (class 1259 OID 131754)
-- Name: sys_job_log; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_job_log (
    job_log_id bigint DEFAULT nextval('ruoyi.seq_sys_job_log_job_log_id'::regclass) NOT NULL,
    job_name character varying(64) NOT NULL,
    job_group character varying(64) NOT NULL,
    invoke_target character varying(500) NOT NULL,
    job_message character varying(500),
    status character(1) DEFAULT '0'::bpchar,
    exception_info character varying(2000) DEFAULT ''::character varying,
    create_time timestamp without time zone
);


ALTER TABLE ruoyi.sys_job_log OWNER TO highgo;

--
-- TOC entry 4458 (class 0 OID 0)
-- Dependencies: 333
-- Name: COLUMN sys_job_log.job_log_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job_log.job_log_id IS '任务日志ID';


--
-- TOC entry 4459 (class 0 OID 0)
-- Dependencies: 333
-- Name: COLUMN sys_job_log.job_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job_log.job_name IS '任务名称';


--
-- TOC entry 4460 (class 0 OID 0)
-- Dependencies: 333
-- Name: COLUMN sys_job_log.job_group; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job_log.job_group IS '任务组名';


--
-- TOC entry 4461 (class 0 OID 0)
-- Dependencies: 333
-- Name: COLUMN sys_job_log.invoke_target; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job_log.invoke_target IS '调用目标字符串';


--
-- TOC entry 4462 (class 0 OID 0)
-- Dependencies: 333
-- Name: COLUMN sys_job_log.job_message; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job_log.job_message IS '日志信息';


--
-- TOC entry 4463 (class 0 OID 0)
-- Dependencies: 333
-- Name: COLUMN sys_job_log.status; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job_log.status IS '执行状态（0正常 1失败）';


--
-- TOC entry 4464 (class 0 OID 0)
-- Dependencies: 333
-- Name: COLUMN sys_job_log.exception_info; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job_log.exception_info IS '异常信息';


--
-- TOC entry 4465 (class 0 OID 0)
-- Dependencies: 333
-- Name: COLUMN sys_job_log.create_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_job_log.create_time IS '创建时间';


--
-- TOC entry 334 (class 1259 OID 131762)
-- Name: sys_logininfor; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_logininfor (
    info_id bigint DEFAULT nextval('ruoyi.seq_sys_logininfor_info_id'::regclass) NOT NULL,
    user_name character varying(50) DEFAULT ''::character varying,
    ipaddr character varying(128) DEFAULT ''::character varying,
    login_location character varying(255) DEFAULT ''::character varying,
    browser character varying(50) DEFAULT ''::character varying,
    os character varying(50) DEFAULT ''::character varying,
    status character(1) DEFAULT '0'::bpchar,
    msg character varying(255) DEFAULT ''::character varying,
    login_time timestamp without time zone
);


ALTER TABLE ruoyi.sys_logininfor OWNER TO highgo;

--
-- TOC entry 4466 (class 0 OID 0)
-- Dependencies: 334
-- Name: COLUMN sys_logininfor.info_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_logininfor.info_id IS '访问ID';


--
-- TOC entry 4467 (class 0 OID 0)
-- Dependencies: 334
-- Name: COLUMN sys_logininfor.user_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_logininfor.user_name IS '用户账号';


--
-- TOC entry 4468 (class 0 OID 0)
-- Dependencies: 334
-- Name: COLUMN sys_logininfor.ipaddr; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_logininfor.ipaddr IS '登录IP地址';


--
-- TOC entry 4469 (class 0 OID 0)
-- Dependencies: 334
-- Name: COLUMN sys_logininfor.login_location; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_logininfor.login_location IS '登录地点';


--
-- TOC entry 4470 (class 0 OID 0)
-- Dependencies: 334
-- Name: COLUMN sys_logininfor.browser; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_logininfor.browser IS '浏览器类型';


--
-- TOC entry 4471 (class 0 OID 0)
-- Dependencies: 334
-- Name: COLUMN sys_logininfor.os; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_logininfor.os IS '操作系统';


--
-- TOC entry 4472 (class 0 OID 0)
-- Dependencies: 334
-- Name: COLUMN sys_logininfor.status; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_logininfor.status IS '登录状态（0成功 1失败）';


--
-- TOC entry 4473 (class 0 OID 0)
-- Dependencies: 334
-- Name: COLUMN sys_logininfor.msg; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_logininfor.msg IS '提示消息';


--
-- TOC entry 4474 (class 0 OID 0)
-- Dependencies: 334
-- Name: COLUMN sys_logininfor.login_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_logininfor.login_time IS '访问时间';


--
-- TOC entry 336 (class 1259 OID 131784)
-- Name: sys_menu; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_menu (
    menu_id bigint DEFAULT nextval('ruoyi.seq_sys_menu_menu_id'::regclass) NOT NULL,
    menu_name character varying(50) NOT NULL,
    parent_id bigint DEFAULT '0'::bigint,
    order_num integer DEFAULT 0,
    path character varying(200) DEFAULT ''::character varying,
    component character varying(255),
    query character varying(255),
    is_frame integer DEFAULT 1,
    is_cache integer DEFAULT 0,
    menu_type character(1) DEFAULT ''::bpchar,
    visible character(1) DEFAULT '0'::bpchar,
    status character(1) DEFAULT '0'::bpchar,
    perms character varying(100),
    icon character varying(100) DEFAULT '#'::character varying,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500) DEFAULT ''::character varying
);


ALTER TABLE ruoyi.sys_menu OWNER TO highgo;

--
-- TOC entry 4475 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.menu_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.menu_id IS '菜单ID';


--
-- TOC entry 4476 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.menu_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.menu_name IS '菜单名称';


--
-- TOC entry 4477 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.parent_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.parent_id IS '父菜单ID';


--
-- TOC entry 4478 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.order_num; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.order_num IS '显示顺序';


--
-- TOC entry 4479 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.path; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.path IS '路由地址';


--
-- TOC entry 4480 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.component; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.component IS '组件路径';


--
-- TOC entry 4481 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.query; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.query IS '路由参数';


--
-- TOC entry 4482 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.is_frame; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.is_frame IS '是否为外链（0是 1否）';


--
-- TOC entry 4483 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.is_cache; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.is_cache IS '是否缓存（0缓存 1不缓存）';


--
-- TOC entry 4484 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.menu_type; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.menu_type IS '菜单类型（M目录 C菜单 F按钮）';


--
-- TOC entry 4485 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.visible; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.visible IS '菜单状态（0显示 1隐藏）';


--
-- TOC entry 4486 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.status; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.status IS '菜单状态（0正常 1停用）';


--
-- TOC entry 4487 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.perms; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.perms IS '权限标识';


--
-- TOC entry 4488 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.icon; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.icon IS '菜单图标';


--
-- TOC entry 4489 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.create_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.create_by IS '创建者';


--
-- TOC entry 4490 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.create_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.create_time IS '创建时间';


--
-- TOC entry 4491 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.update_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.update_by IS '更新者';


--
-- TOC entry 4492 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.update_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.update_time IS '更新时间';


--
-- TOC entry 4493 (class 0 OID 0)
-- Dependencies: 336
-- Name: COLUMN sys_menu.remark; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_menu.remark IS '备注';


--
-- TOC entry 335 (class 1259 OID 131763)
-- Name: sys_notice; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_notice (
    notice_id integer DEFAULT nextval('ruoyi.seq_sys_notice_notice_id'::regclass) NOT NULL,
    notice_title character varying(50) NOT NULL,
    notice_type character(1) NOT NULL,
    notice_content bytea,
    status character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(255)
);


ALTER TABLE ruoyi.sys_notice OWNER TO highgo;

--
-- TOC entry 4494 (class 0 OID 0)
-- Dependencies: 335
-- Name: COLUMN sys_notice.notice_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_notice.notice_id IS '公告ID';


--
-- TOC entry 4495 (class 0 OID 0)
-- Dependencies: 335
-- Name: COLUMN sys_notice.notice_title; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_notice.notice_title IS '公告标题';


--
-- TOC entry 4496 (class 0 OID 0)
-- Dependencies: 335
-- Name: COLUMN sys_notice.notice_type; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_notice.notice_type IS '公告类型（1通知 2公告）';


--
-- TOC entry 4497 (class 0 OID 0)
-- Dependencies: 335
-- Name: COLUMN sys_notice.notice_content; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_notice.notice_content IS '公告内容';


--
-- TOC entry 4498 (class 0 OID 0)
-- Dependencies: 335
-- Name: COLUMN sys_notice.status; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_notice.status IS '公告状态（0正常 1关闭）';


--
-- TOC entry 4499 (class 0 OID 0)
-- Dependencies: 335
-- Name: COLUMN sys_notice.create_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_notice.create_by IS '创建者';


--
-- TOC entry 4500 (class 0 OID 0)
-- Dependencies: 335
-- Name: COLUMN sys_notice.create_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_notice.create_time IS '创建时间';


--
-- TOC entry 4501 (class 0 OID 0)
-- Dependencies: 335
-- Name: COLUMN sys_notice.update_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_notice.update_by IS '更新者';


--
-- TOC entry 4502 (class 0 OID 0)
-- Dependencies: 335
-- Name: COLUMN sys_notice.update_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_notice.update_time IS '更新时间';


--
-- TOC entry 4503 (class 0 OID 0)
-- Dependencies: 335
-- Name: COLUMN sys_notice.remark; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_notice.remark IS '备注';


--
-- TOC entry 339 (class 1259 OID 131817)
-- Name: sys_oper_log; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_oper_log (
    oper_id bigint DEFAULT nextval('ruoyi.seq_sys_oper_log_oper_id'::regclass) NOT NULL,
    title character varying(50) DEFAULT ''::character varying,
    business_type integer DEFAULT 0,
    method character varying(100) DEFAULT ''::character varying,
    request_method character varying(10) DEFAULT ''::character varying,
    operator_type integer DEFAULT 0,
    oper_name character varying(50) DEFAULT ''::character varying,
    dept_name character varying(50) DEFAULT ''::character varying,
    oper_url character varying(255) DEFAULT ''::character varying,
    oper_ip character varying(128) DEFAULT ''::character varying,
    oper_location character varying(255) DEFAULT ''::character varying,
    oper_param character varying(2000) DEFAULT ''::character varying,
    json_result character varying(2000) DEFAULT ''::character varying,
    status integer DEFAULT 0,
    error_msg character varying(2000) DEFAULT ''::character varying,
    oper_time timestamp without time zone,
    cost_time bigint DEFAULT '0'::bigint
);


ALTER TABLE ruoyi.sys_oper_log OWNER TO highgo;

--
-- TOC entry 4504 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.oper_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.oper_id IS '日志主键';


--
-- TOC entry 4505 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.title; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.title IS '模块标题';


--
-- TOC entry 4506 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.business_type; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.business_type IS '业务类型（0其它 1新增 2修改 3删除）';


--
-- TOC entry 4507 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.method; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.method IS '方法名称';


--
-- TOC entry 4508 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.request_method; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.request_method IS '请求方式';


--
-- TOC entry 4509 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.operator_type; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.operator_type IS '操作类别（0其它 1后台用户 2手机端用户）';


--
-- TOC entry 4510 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.oper_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.oper_name IS '操作人员';


--
-- TOC entry 4511 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.dept_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.dept_name IS '部门名称';


--
-- TOC entry 4512 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.oper_url; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.oper_url IS '请求URL';


--
-- TOC entry 4513 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.oper_ip; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.oper_ip IS '主机地址';


--
-- TOC entry 4514 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.oper_location; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.oper_location IS '操作地点';


--
-- TOC entry 4515 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.oper_param; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.oper_param IS '请求参数';


--
-- TOC entry 4516 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.json_result; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.json_result IS '返回参数';


--
-- TOC entry 4517 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.status; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.status IS '操作状态（0正常 1异常）';


--
-- TOC entry 4518 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.error_msg; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.error_msg IS '错误消息';


--
-- TOC entry 4519 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.oper_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.oper_time IS '操作时间';


--
-- TOC entry 4520 (class 0 OID 0)
-- Dependencies: 339
-- Name: COLUMN sys_oper_log.cost_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_oper_log.cost_time IS '消耗时间';


--
-- TOC entry 344 (class 1259 OID 131864)
-- Name: sys_post; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_post (
    post_id bigint DEFAULT nextval('ruoyi.seq_sys_post_post_id'::regclass) NOT NULL,
    post_code character varying(64) NOT NULL,
    post_name character varying(50) NOT NULL,
    post_sort integer NOT NULL,
    status character(1) NOT NULL,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500)
);


ALTER TABLE ruoyi.sys_post OWNER TO highgo;

--
-- TOC entry 4521 (class 0 OID 0)
-- Dependencies: 344
-- Name: COLUMN sys_post.post_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_post.post_id IS '岗位ID';


--
-- TOC entry 4522 (class 0 OID 0)
-- Dependencies: 344
-- Name: COLUMN sys_post.post_code; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_post.post_code IS '岗位编码';


--
-- TOC entry 4523 (class 0 OID 0)
-- Dependencies: 344
-- Name: COLUMN sys_post.post_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_post.post_name IS '岗位名称';


--
-- TOC entry 4524 (class 0 OID 0)
-- Dependencies: 344
-- Name: COLUMN sys_post.post_sort; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_post.post_sort IS '显示顺序';


--
-- TOC entry 4525 (class 0 OID 0)
-- Dependencies: 344
-- Name: COLUMN sys_post.status; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_post.status IS '状态（0正常 1停用）';


--
-- TOC entry 4526 (class 0 OID 0)
-- Dependencies: 344
-- Name: COLUMN sys_post.create_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_post.create_by IS '创建者';


--
-- TOC entry 4527 (class 0 OID 0)
-- Dependencies: 344
-- Name: COLUMN sys_post.create_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_post.create_time IS '创建时间';


--
-- TOC entry 4528 (class 0 OID 0)
-- Dependencies: 344
-- Name: COLUMN sys_post.update_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_post.update_by IS '更新者';


--
-- TOC entry 4529 (class 0 OID 0)
-- Dependencies: 344
-- Name: COLUMN sys_post.update_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_post.update_time IS '更新时间';


--
-- TOC entry 4530 (class 0 OID 0)
-- Dependencies: 344
-- Name: COLUMN sys_post.remark; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_post.remark IS '备注';


--
-- TOC entry 337 (class 1259 OID 131802)
-- Name: sys_role; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_role (
    role_id bigint DEFAULT nextval('ruoyi.seq_sys_role_role_id'::regclass) NOT NULL,
    role_name character varying(30) NOT NULL,
    role_key character varying(100) NOT NULL,
    role_sort integer NOT NULL,
    data_scope character(1) DEFAULT '1'::bpchar,
    menu_check_strictly smallint DEFAULT '1'::smallint,
    dept_check_strictly smallint DEFAULT '1'::smallint,
    status character(1) NOT NULL,
    del_flag character(1) DEFAULT '0'::bpchar,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500)
);


ALTER TABLE ruoyi.sys_role OWNER TO highgo;

--
-- TOC entry 4531 (class 0 OID 0)
-- Dependencies: 337
-- Name: COLUMN sys_role.role_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role.role_id IS '角色ID';


--
-- TOC entry 4532 (class 0 OID 0)
-- Dependencies: 337
-- Name: COLUMN sys_role.role_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role.role_name IS '角色名称';


--
-- TOC entry 4533 (class 0 OID 0)
-- Dependencies: 337
-- Name: COLUMN sys_role.role_key; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role.role_key IS '角色权限字符串';


--
-- TOC entry 4534 (class 0 OID 0)
-- Dependencies: 337
-- Name: COLUMN sys_role.role_sort; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role.role_sort IS '显示顺序';


--
-- TOC entry 4535 (class 0 OID 0)
-- Dependencies: 337
-- Name: COLUMN sys_role.data_scope; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role.data_scope IS '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）';


--
-- TOC entry 4536 (class 0 OID 0)
-- Dependencies: 337
-- Name: COLUMN sys_role.menu_check_strictly; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role.menu_check_strictly IS '菜单树选择项是否关联显示';


--
-- TOC entry 4537 (class 0 OID 0)
-- Dependencies: 337
-- Name: COLUMN sys_role.dept_check_strictly; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role.dept_check_strictly IS '部门树选择项是否关联显示';


--
-- TOC entry 4538 (class 0 OID 0)
-- Dependencies: 337
-- Name: COLUMN sys_role.status; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role.status IS '角色状态（0正常 1停用）';


--
-- TOC entry 4539 (class 0 OID 0)
-- Dependencies: 337
-- Name: COLUMN sys_role.del_flag; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role.del_flag IS '删除标志（0代表存在 2代表删除）';


--
-- TOC entry 4540 (class 0 OID 0)
-- Dependencies: 337
-- Name: COLUMN sys_role.create_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role.create_by IS '创建者';


--
-- TOC entry 4541 (class 0 OID 0)
-- Dependencies: 337
-- Name: COLUMN sys_role.create_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role.create_time IS '创建时间';


--
-- TOC entry 4542 (class 0 OID 0)
-- Dependencies: 337
-- Name: COLUMN sys_role.update_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role.update_by IS '更新者';


--
-- TOC entry 4543 (class 0 OID 0)
-- Dependencies: 337
-- Name: COLUMN sys_role.update_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role.update_time IS '更新时间';


--
-- TOC entry 4544 (class 0 OID 0)
-- Dependencies: 337
-- Name: COLUMN sys_role.remark; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role.remark IS '备注';


--
-- TOC entry 338 (class 1259 OID 131814)
-- Name: sys_role_dept; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_role_dept (
    role_id bigint NOT NULL,
    dept_id bigint NOT NULL
);


ALTER TABLE ruoyi.sys_role_dept OWNER TO highgo;

--
-- TOC entry 4545 (class 0 OID 0)
-- Dependencies: 338
-- Name: COLUMN sys_role_dept.role_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role_dept.role_id IS '角色ID';


--
-- TOC entry 4546 (class 0 OID 0)
-- Dependencies: 338
-- Name: COLUMN sys_role_dept.dept_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role_dept.dept_id IS '部门ID';


--
-- TOC entry 341 (class 1259 OID 131839)
-- Name: sys_role_menu; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_role_menu (
    role_id bigint NOT NULL,
    menu_id bigint NOT NULL
);


ALTER TABLE ruoyi.sys_role_menu OWNER TO highgo;

--
-- TOC entry 4547 (class 0 OID 0)
-- Dependencies: 341
-- Name: COLUMN sys_role_menu.role_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role_menu.role_id IS '角色ID';


--
-- TOC entry 4548 (class 0 OID 0)
-- Dependencies: 341
-- Name: COLUMN sys_role_menu.menu_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_role_menu.menu_id IS '菜单ID';


--
-- TOC entry 340 (class 1259 OID 131838)
-- Name: sys_user; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_user (
    user_id bigint DEFAULT nextval('ruoyi.seq_sys_user_user_id'::regclass) NOT NULL,
    dept_id bigint,
    user_name character varying(30) NOT NULL,
    nick_name character varying(30) NOT NULL,
    user_type character varying(2) DEFAULT '00'::character varying,
    email character varying(50) DEFAULT ''::character varying,
    phonenumber character varying(11) DEFAULT ''::character varying,
    sex character(1) DEFAULT '0'::bpchar,
    avatar character varying(100) DEFAULT ''::character varying,
    password character varying(100) DEFAULT ''::character varying,
    status character(1) DEFAULT '0'::bpchar,
    del_flag character(1) DEFAULT '0'::bpchar,
    login_ip character varying(128) DEFAULT ''::character varying,
    login_date timestamp without time zone,
    create_by character varying(64) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_by character varying(64) DEFAULT ''::character varying,
    update_time timestamp without time zone,
    remark character varying(500)
);


ALTER TABLE ruoyi.sys_user OWNER TO highgo;

--
-- TOC entry 4549 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.user_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.user_id IS '用户ID';


--
-- TOC entry 4550 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.dept_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.dept_id IS '部门ID';


--
-- TOC entry 4551 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.user_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.user_name IS '用户账号';


--
-- TOC entry 4552 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.nick_name; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.nick_name IS '用户昵称';


--
-- TOC entry 4553 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.user_type; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.user_type IS '用户类型（00系统用户）';


--
-- TOC entry 4554 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.email; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.email IS '用户邮箱';


--
-- TOC entry 4555 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.phonenumber; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.phonenumber IS '手机号码';


--
-- TOC entry 4556 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.sex; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.sex IS '用户性别（0男 1女 2未知）';


--
-- TOC entry 4557 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.avatar; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.avatar IS '头像地址';


--
-- TOC entry 4558 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.password; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.password IS '密码';


--
-- TOC entry 4559 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.status; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.status IS '帐号状态（0正常 1停用）';


--
-- TOC entry 4560 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.del_flag; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.del_flag IS '删除标志（0代表存在 2代表删除）';


--
-- TOC entry 4561 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.login_ip; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.login_ip IS '最后登录IP';


--
-- TOC entry 4562 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.login_date; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.login_date IS '最后登录时间';


--
-- TOC entry 4563 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.create_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.create_by IS '创建者';


--
-- TOC entry 4564 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.create_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.create_time IS '创建时间';


--
-- TOC entry 4565 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.update_by; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.update_by IS '更新者';


--
-- TOC entry 4566 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.update_time; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.update_time IS '更新时间';


--
-- TOC entry 4567 (class 0 OID 0)
-- Dependencies: 340
-- Name: COLUMN sys_user.remark; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user.remark IS '备注';


--
-- TOC entry 343 (class 1259 OID 131859)
-- Name: sys_user_post; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_user_post (
    user_id bigint NOT NULL,
    post_id bigint NOT NULL
);


ALTER TABLE ruoyi.sys_user_post OWNER TO highgo;

--
-- TOC entry 4568 (class 0 OID 0)
-- Dependencies: 343
-- Name: COLUMN sys_user_post.user_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user_post.user_id IS '用户ID';


--
-- TOC entry 4569 (class 0 OID 0)
-- Dependencies: 343
-- Name: COLUMN sys_user_post.post_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user_post.post_id IS '岗位ID';


--
-- TOC entry 342 (class 1259 OID 131858)
-- Name: sys_user_role; Type: TABLE; Schema: ruoyi; Owner: highgo
--

CREATE TABLE ruoyi.sys_user_role (
    user_id bigint NOT NULL,
    role_id bigint NOT NULL
);


ALTER TABLE ruoyi.sys_user_role OWNER TO highgo;

--
-- TOC entry 4570 (class 0 OID 0)
-- Dependencies: 342
-- Name: COLUMN sys_user_role.user_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user_role.user_id IS '用户ID';


--
-- TOC entry 4571 (class 0 OID 0)
-- Dependencies: 342
-- Name: COLUMN sys_user_role.role_id; Type: COMMENT; Schema: ruoyi; Owner: highgo
--

COMMENT ON COLUMN ruoyi.sys_user_role.role_id IS '角色ID';


--
-- TOC entry 4232 (class 0 OID 131634)
-- Dependencies: 320
-- Data for Name: gen_table; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.gen_table VALUES (3, 'part_2011', '', NULL, NULL, 'Part2011', 'crud', 'com.ruoyi.system', 'system', '2011', NULL, 'ruoyi', '0', '/', NULL, 'admin', '2023-09-18 13:55:46.01024', '', NULL, NULL);
INSERT INTO ruoyi.gen_table VALUES (1, 't1', '测试表', NULL, NULL, 'T1', 'crud', 'com.ruoyi.system', 'system', 't1', '测试', 'ruoyi', '0', '/', '{}', 'admin', '2023-09-18 13:28:04.82863', '', '2023-09-18 13:59:32.515376', NULL);


--
-- TOC entry 4234 (class 0 OID 131654)
-- Dependencies: 322
-- Data for Name: gen_table_column; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.gen_table_column VALUES (4, 3, 'aaz351', NULL, 'character varying', 'String', 'aaz351', '1', '0', '0', '1', NULL, NULL, NULL, 'EQ', NULL, '', 1, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (5, 3, 'aac001', NULL, 'character varying', 'String', 'aac001', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 2, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (6, 3, 'bie011', NULL, 'character varying', 'String', 'bie011', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 3, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (7, 3, 'aae149', NULL, 'character varying', 'String', 'aae149', '1', '0', '0', '1', NULL, NULL, NULL, 'EQ', NULL, '', 4, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (8, 3, 'aae140', NULL, 'character varying', 'String', 'aae140', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 5, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (9, 3, 'aaa036', NULL, 'character varying', 'String', 'aaa036', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 6, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (10, 3, 'aae019', NULL, 'numeric', 'String', 'aae019', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 7, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (11, 3, 'aae072', NULL, 'character varying', 'String', 'aae072', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 8, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (12, 3, 'aae002', NULL, 'character varying', 'String', 'aae002', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 9, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (13, 3, 'aae013', NULL, 'character varying', 'String', 'aae013', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 10, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (14, 3, 'aae011', NULL, 'character varying', 'String', 'aae011', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 11, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (15, 3, 'aae036', NULL, 'timestamp without time zone', 'String', 'aae036', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 12, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (16, 3, 'bae013', NULL, 'character varying', 'String', 'bae013', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 13, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (17, 3, 'aid001', NULL, 'character varying', 'String', 'aid001', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 14, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (18, 3, 'cic003', NULL, 'character varying', 'String', 'cic003', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 15, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (19, 3, 'cic008', NULL, 'character varying', 'String', 'cic008', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 16, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (20, 3, 'cic009', NULL, 'character varying', 'String', 'cic009', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 17, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (21, 3, 'aaz039', NULL, 'character varying', 'String', 'aaz039', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 18, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (22, 3, 'cic010', NULL, 'character varying', 'String', 'cic010', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 19, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (23, 3, 'aaz219', NULL, 'numeric', 'String', 'aaz219', '0', '0', '0', '1', '1', '1', '1', 'EQ', NULL, '', 20, 'admin', '2023-09-18 13:55:46.01024', '', NULL);
INSERT INTO ruoyi.gen_table_column VALUES (1, 1, 'id', '序号', 'integer', 'Long', 'id', '0', '0', '0', '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2023-09-18 13:28:04.82863', '', '2023-09-18 13:59:32.515376');
INSERT INTO ruoyi.gen_table_column VALUES (2, 1, 'name', '人员名称', 'character varying', 'String', 'name', '0', '0', '0', '1', '1', '1', '1', 'LIKE', NULL, '', 2, 'admin', '2023-09-18 13:28:04.82863', '', '2023-09-18 13:59:32.515376');


--
-- TOC entry 4229 (class 0 OID 131619)
-- Dependencies: 317
-- Data for Name: qrtz_blob_triggers; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--



--
-- TOC entry 4227 (class 0 OID 131610)
-- Dependencies: 315
-- Data for Name: qrtz_calendars; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--



--
-- TOC entry 4236 (class 0 OID 131667)
-- Dependencies: 324
-- Data for Name: qrtz_cron_triggers; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--



--
-- TOC entry 4230 (class 0 OID 131625)
-- Dependencies: 318
-- Data for Name: qrtz_fired_triggers; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--



--
-- TOC entry 4233 (class 0 OID 131648)
-- Dependencies: 321
-- Data for Name: qrtz_job_details; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--



--
-- TOC entry 4228 (class 0 OID 131616)
-- Dependencies: 316
-- Data for Name: qrtz_locks; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--



--
-- TOC entry 4231 (class 0 OID 131631)
-- Dependencies: 319
-- Data for Name: qrtz_paused_trigger_grps; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--



--
-- TOC entry 4235 (class 0 OID 131664)
-- Dependencies: 323
-- Data for Name: qrtz_scheduler_state; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--



--
-- TOC entry 4241 (class 0 OID 131708)
-- Dependencies: 329
-- Data for Name: qrtz_simple_triggers; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--



--
-- TOC entry 4239 (class 0 OID 131680)
-- Dependencies: 327
-- Data for Name: qrtz_simprop_triggers; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--



--
-- TOC entry 4237 (class 0 OID 131673)
-- Dependencies: 325
-- Data for Name: qrtz_triggers; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--



--
-- TOC entry 4238 (class 0 OID 131679)
-- Dependencies: 326
-- Data for Name: sys_config; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.sys_config VALUES (1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2023-09-18 10:20:16', '', NULL, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
INSERT INTO ruoyi.sys_config VALUES (2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2023-09-18 10:20:16', '', NULL, '初始化密码 123456');
INSERT INTO ruoyi.sys_config VALUES (3, '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2023-09-18 10:20:16', '', NULL, '深色主题theme-dark，浅色主题theme-light');
INSERT INTO ruoyi.sys_config VALUES (4, '账号自助-验证码开关', 'sys.account.captchaEnabled', 'true', 'Y', 'admin', '2023-09-18 10:20:16', '', NULL, '是否开启验证码功能（true开启，false关闭）');
INSERT INTO ruoyi.sys_config VALUES (5, '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2023-09-18 10:20:16', '', NULL, '是否开启注册用户功能（true开启，false关闭）');
INSERT INTO ruoyi.sys_config VALUES (6, '用户登录-黑名单列表', 'sys.login.blackIPList', '', 'Y', 'admin', '2023-09-18 10:20:16', '', NULL, '设置登录IP黑名单限制，多个匹配项以;分隔，支持匹配（*通配、网段）');


--
-- TOC entry 4240 (class 0 OID 131697)
-- Dependencies: 328
-- Data for Name: sys_dept; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.sys_dept VALUES (103, 101, '0,100,101', '研发部门', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-09-18 10:20:15', '', NULL);
INSERT INTO ruoyi.sys_dept VALUES (104, 101, '0,100,101', '市场部门', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-09-18 10:20:15', '', NULL);
INSERT INTO ruoyi.sys_dept VALUES (105, 101, '0,100,101', '测试部门', 3, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-09-18 10:20:15', '', NULL);
INSERT INTO ruoyi.sys_dept VALUES (106, 101, '0,100,101', '财务部门', 4, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-09-18 10:20:15', '', NULL);
INSERT INTO ruoyi.sys_dept VALUES (107, 101, '0,100,101', '运维部门', 5, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-09-18 10:20:15', '', NULL);
INSERT INTO ruoyi.sys_dept VALUES (108, 102, '0,100,102', '市场部门', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-09-18 10:20:15', '', NULL);
INSERT INTO ruoyi.sys_dept VALUES (109, 102, '0,100,102', '财务部门', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-09-18 10:20:15', '', NULL);
INSERT INTO ruoyi.sys_dept VALUES (100, 0, '0', '瀚高股份有限公司', 0, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-09-18 10:20:15', '', NULL);
INSERT INTO ruoyi.sys_dept VALUES (101, 100, '0,100', '北京总公司', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-09-18 10:20:15', '', NULL);
INSERT INTO ruoyi.sys_dept VALUES (102, 100, '0,100', '济南分公司', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2023-09-18 10:20:15', '', NULL);


--
-- TOC entry 4242 (class 0 OID 131714)
-- Dependencies: 330
-- Data for Name: sys_dict_data; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.sys_dict_data VALUES (1, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '性别男');
INSERT INTO ruoyi.sys_dict_data VALUES (2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '性别女');
INSERT INTO ruoyi.sys_dict_data VALUES (3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '性别未知');
INSERT INTO ruoyi.sys_dict_data VALUES (4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '显示菜单');
INSERT INTO ruoyi.sys_dict_data VALUES (5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '隐藏菜单');
INSERT INTO ruoyi.sys_dict_data VALUES (6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '正常状态');
INSERT INTO ruoyi.sys_dict_data VALUES (7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '停用状态');
INSERT INTO ruoyi.sys_dict_data VALUES (8, 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '正常状态');
INSERT INTO ruoyi.sys_dict_data VALUES (9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '停用状态');
INSERT INTO ruoyi.sys_dict_data VALUES (10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '默认分组');
INSERT INTO ruoyi.sys_dict_data VALUES (11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '系统分组');
INSERT INTO ruoyi.sys_dict_data VALUES (12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '系统默认是');
INSERT INTO ruoyi.sys_dict_data VALUES (13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '系统默认否');
INSERT INTO ruoyi.sys_dict_data VALUES (14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '通知');
INSERT INTO ruoyi.sys_dict_data VALUES (15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '公告');
INSERT INTO ruoyi.sys_dict_data VALUES (16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '正常状态');
INSERT INTO ruoyi.sys_dict_data VALUES (17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '关闭状态');
INSERT INTO ruoyi.sys_dict_data VALUES (18, 99, '其他', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '其他操作');
INSERT INTO ruoyi.sys_dict_data VALUES (19, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '新增操作');
INSERT INTO ruoyi.sys_dict_data VALUES (20, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '修改操作');
INSERT INTO ruoyi.sys_dict_data VALUES (21, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '删除操作');
INSERT INTO ruoyi.sys_dict_data VALUES (22, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '授权操作');
INSERT INTO ruoyi.sys_dict_data VALUES (23, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '导出操作');
INSERT INTO ruoyi.sys_dict_data VALUES (24, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '导入操作');
INSERT INTO ruoyi.sys_dict_data VALUES (25, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '强退操作');
INSERT INTO ruoyi.sys_dict_data VALUES (26, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '生成操作');
INSERT INTO ruoyi.sys_dict_data VALUES (27, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '清空操作');
INSERT INTO ruoyi.sys_dict_data VALUES (28, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '正常状态');
INSERT INTO ruoyi.sys_dict_data VALUES (29, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '停用状态');


--
-- TOC entry 4244 (class 0 OID 131716)
-- Dependencies: 332
-- Data for Name: sys_dict_type; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.sys_dict_type VALUES (1, '用户性别', 'sys_user_sex', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '用户性别列表');
INSERT INTO ruoyi.sys_dict_type VALUES (2, '菜单状态', 'sys_show_hide', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '菜单状态列表');
INSERT INTO ruoyi.sys_dict_type VALUES (3, '系统开关', 'sys_normal_disable', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '系统开关列表');
INSERT INTO ruoyi.sys_dict_type VALUES (4, '任务状态', 'sys_job_status', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '任务状态列表');
INSERT INTO ruoyi.sys_dict_type VALUES (5, '任务分组', 'sys_job_group', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '任务分组列表');
INSERT INTO ruoyi.sys_dict_type VALUES (6, '系统是否', 'sys_yes_no', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '系统是否列表');
INSERT INTO ruoyi.sys_dict_type VALUES (7, '通知类型', 'sys_notice_type', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '通知类型列表');
INSERT INTO ruoyi.sys_dict_type VALUES (8, '通知状态', 'sys_notice_status', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '通知状态列表');
INSERT INTO ruoyi.sys_dict_type VALUES (9, '操作类型', 'sys_oper_type', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '操作类型列表');
INSERT INTO ruoyi.sys_dict_type VALUES (10, '系统状态', 'sys_common_status', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '登录状态列表');


--
-- TOC entry 4243 (class 0 OID 131715)
-- Dependencies: 331
-- Data for Name: sys_job; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.sys_job VALUES (1, '系统默认（无参）', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', '2023-09-18 10:20:16', '', NULL, '');
INSERT INTO ruoyi.sys_job VALUES (3, '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(''ry'', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', '2023-09-18 10:20:16', '', NULL, '');
INSERT INTO ruoyi.sys_job VALUES (2, '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(''ry'')', '0/15 * * * * ?', '3', '1', '1', 'admin', '2023-09-18 10:20:16', '', '2023-09-18 13:29:09.859828', '');


--
-- TOC entry 4245 (class 0 OID 131754)
-- Dependencies: 333
-- Data for Name: sys_job_log; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--



--
-- TOC entry 4246 (class 0 OID 131762)
-- Dependencies: 334
-- Data for Name: sys_logininfor; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.sys_logininfor VALUES (1, 'admin', '127.0.0.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-09-18 13:12:03.253834');
INSERT INTO ruoyi.sys_logininfor VALUES (2, 'admin', '192.168.52.1', '内网IP', 'Chrome 11', 'Windows 10', '0', '登录成功', '2023-09-18 13:13:26.318944');


--
-- TOC entry 4248 (class 0 OID 131784)
-- Dependencies: 336
-- Data for Name: sys_menu; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.sys_menu VALUES (1, '系统管理', 0, 1, 'system', NULL, '', 1, 0, 'M', '0', '0', '', 'system', 'admin', '2023-09-18 10:20:15', '', NULL, '系统管理目录');
INSERT INTO ruoyi.sys_menu VALUES (2, '系统监控', 0, 2, 'monitor', NULL, '', 1, 0, 'M', '0', '0', '', 'monitor', 'admin', '2023-09-18 10:20:15', '', NULL, '系统监控目录');
INSERT INTO ruoyi.sys_menu VALUES (3, '系统工具', 0, 3, 'tool', NULL, '', 1, 0, 'M', '0', '0', '', 'tool', 'admin', '2023-09-18 10:20:15', '', NULL, '系统工具目录');
INSERT INTO ruoyi.sys_menu VALUES (4, '若依官网', 0, 4, 'http://ruoyi.vip', NULL, '', 0, 0, 'M', '0', '0', '', 'guide', 'admin', '2023-09-18 10:20:15', '', NULL, '若依官网地址');
INSERT INTO ruoyi.sys_menu VALUES (100, '用户管理', 1, 1, 'user', 'system/user/index', '', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 'admin', '2023-09-18 10:20:15', '', NULL, '用户管理菜单');
INSERT INTO ruoyi.sys_menu VALUES (101, '角色管理', 1, 2, 'role', 'system/role/index', '', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 'admin', '2023-09-18 10:20:15', '', NULL, '角色管理菜单');
INSERT INTO ruoyi.sys_menu VALUES (102, '菜单管理', 1, 3, 'menu', 'system/menu/index', '', 1, 0, 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', '2023-09-18 10:20:15', '', NULL, '菜单管理菜单');
INSERT INTO ruoyi.sys_menu VALUES (103, '部门管理', 1, 4, 'dept', 'system/dept/index', '', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 'admin', '2023-09-18 10:20:15', '', NULL, '部门管理菜单');
INSERT INTO ruoyi.sys_menu VALUES (104, '岗位管理', 1, 5, 'post', 'system/post/index', '', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 'admin', '2023-09-18 10:20:15', '', NULL, '岗位管理菜单');
INSERT INTO ruoyi.sys_menu VALUES (105, '字典管理', 1, 6, 'dict', 'system/dict/index', '', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 'admin', '2023-09-18 10:20:15', '', NULL, '字典管理菜单');
INSERT INTO ruoyi.sys_menu VALUES (106, '参数设置', 1, 7, 'config', 'system/config/index', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', '2023-09-18 10:20:15', '', NULL, '参数设置菜单');
INSERT INTO ruoyi.sys_menu VALUES (107, '通知公告', 1, 8, 'notice', 'system/notice/index', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', '2023-09-18 10:20:15', '', NULL, '通知公告菜单');
INSERT INTO ruoyi.sys_menu VALUES (108, '日志管理', 1, 9, 'log', '', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', '2023-09-18 10:20:15', '', NULL, '日志管理菜单');
INSERT INTO ruoyi.sys_menu VALUES (109, '在线用户', 2, 1, 'online', 'monitor/online/index', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', '2023-09-18 10:20:15', '', NULL, '在线用户菜单');
INSERT INTO ruoyi.sys_menu VALUES (110, '定时任务', 2, 2, 'job', 'monitor/job/index', '', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job', 'admin', '2023-09-18 10:20:15', '', NULL, '定时任务菜单');
INSERT INTO ruoyi.sys_menu VALUES (111, '数据监控', 2, 3, 'druid', 'monitor/druid/index', '', 1, 0, 'C', '0', '0', 'monitor:druid:list', 'druid', 'admin', '2023-09-18 10:20:15', '', NULL, '数据监控菜单');
INSERT INTO ruoyi.sys_menu VALUES (112, '服务监控', 2, 4, 'server', 'monitor/server/index', '', 1, 0, 'C', '0', '0', 'monitor:server:list', 'server', 'admin', '2023-09-18 10:20:15', '', NULL, '服务监控菜单');
INSERT INTO ruoyi.sys_menu VALUES (113, '缓存监控', 2, 5, 'cache', 'monitor/cache/index', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis', 'admin', '2023-09-18 10:20:15', '', NULL, '缓存监控菜单');
INSERT INTO ruoyi.sys_menu VALUES (114, '缓存列表', 2, 6, 'cacheList', 'monitor/cache/list', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis-list', 'admin', '2023-09-18 10:20:15', '', NULL, '缓存列表菜单');
INSERT INTO ruoyi.sys_menu VALUES (115, '表单构建', 3, 1, 'build', 'tool/build/index', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 'admin', '2023-09-18 10:20:15', '', NULL, '表单构建菜单');
INSERT INTO ruoyi.sys_menu VALUES (116, '代码生成', 3, 2, 'gen', 'tool/gen/index', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 'admin', '2023-09-18 10:20:15', '', NULL, '代码生成菜单');
INSERT INTO ruoyi.sys_menu VALUES (117, '系统接口', 3, 3, 'swagger', 'tool/swagger/index', '', 1, 0, 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', '2023-09-18 10:20:15', '', NULL, '系统接口菜单');
INSERT INTO ruoyi.sys_menu VALUES (500, '操作日志', 108, 1, 'operlog', 'monitor/operlog/index', '', 1, 0, 'C', '0', '0', 'monitor:operlog:list', 'form', 'admin', '2023-09-18 10:20:15', '', NULL, '操作日志菜单');
INSERT INTO ruoyi.sys_menu VALUES (501, '登录日志', 108, 2, 'logininfor', 'monitor/logininfor/index', '', 1, 0, 'C', '0', '0', 'monitor:logininfor:list', 'logininfor', 'admin', '2023-09-18 10:20:15', '', NULL, '登录日志菜单');
INSERT INTO ruoyi.sys_menu VALUES (1000, '用户查询', 100, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1001, '用户新增', 100, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1002, '用户修改', 100, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1003, '用户删除', 100, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1004, '用户导出', 100, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1005, '用户导入', 100, 6, '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1006, '重置密码', 100, 7, '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1007, '角色查询', 101, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1008, '角色新增', 101, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1009, '角色修改', 101, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1010, '角色删除', 101, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1011, '角色导出', 101, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1012, '菜单查询', 102, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1013, '菜单新增', 102, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1014, '菜单修改', 102, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1015, '菜单删除', 102, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1016, '部门查询', 103, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1017, '部门新增', 103, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1018, '部门修改', 103, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1019, '部门删除', 103, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1020, '岗位查询', 104, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1021, '岗位新增', 104, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1022, '岗位修改', 104, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1023, '岗位删除', 104, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1024, '岗位导出', 104, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1025, '字典查询', 105, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1026, '字典新增', 105, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1027, '字典修改', 105, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1028, '字典删除', 105, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1029, '字典导出', 105, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1030, '参数查询', 106, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1031, '参数新增', 106, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1032, '参数修改', 106, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1033, '参数删除', 106, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1034, '参数导出', 106, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1035, '公告查询', 107, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1036, '公告新增', 107, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1037, '公告修改', 107, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1038, '公告删除', 107, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1039, '操作查询', 500, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1040, '操作删除', 500, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1041, '日志导出', 500, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1042, '登录查询', 501, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:query', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1043, '登录删除', 501, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:remove', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1044, '日志导出', 501, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:export', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1045, '账户解锁', 501, 4, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:unlock', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1046, '在线查询', 109, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1047, '批量强退', 109, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1048, '单条强退', 109, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1049, '任务查询', 110, 1, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:query', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1050, '任务新增', 110, 2, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:add', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1051, '任务修改', 110, 3, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:edit', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1052, '任务删除', 110, 4, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:remove', '#', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1053, '状态修改', 110, 5, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', '2023-09-18 10:20:16', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1054, '任务导出', 110, 6, '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:export', '#', 'admin', '2023-09-18 10:20:16', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1055, '生成查询', 116, 1, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', '2023-09-18 10:20:16', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1056, '生成修改', 116, 2, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', '2023-09-18 10:20:16', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1057, '生成删除', 116, 3, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', '2023-09-18 10:20:16', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1058, '导入代码', 116, 4, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', '2023-09-18 10:20:16', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1059, '预览代码', 116, 5, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', '2023-09-18 10:20:16', '', NULL, '');
INSERT INTO ruoyi.sys_menu VALUES (1060, '生成代码', 116, 6, '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', '2023-09-18 10:20:16', '', NULL, '');


--
-- TOC entry 4247 (class 0 OID 131763)
-- Dependencies: 335
-- Data for Name: sys_notice; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.sys_notice VALUES (1, '温馨提醒：2018-07-01 若依新版本发布啦', '2', '\xe696b0e78988e69cace58685e5aeb9', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '管理员');
INSERT INTO ruoyi.sys_notice VALUES (2, '维护通知：2018-07-01 若依系统凌晨维护', '1', '\xe7bbb4e68aa4e58685e5aeb9', '0', 'admin', '2023-09-18 10:20:16', '', NULL, '管理员');


--
-- TOC entry 4251 (class 0 OID 131817)
-- Dependencies: 339
-- Data for Name: sys_oper_log; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.sys_oper_log VALUES (1, '用户管理', 2, 'com.ruoyi.web.controller.system.SysUserController.edit()', 'PUT', 1, 'admin', NULL, '/system/user', '192.168.52.1', '内网IP', '{"admin":false,"avatar":"","createBy":"admin","createTime":"2023-09-18 10:20:15","delFlag":"0","dept":{"ancestors":"0,100,101","children":[],"deptId":105,"deptName":"测试部门","leader":"若依","orderNum":3,"params":{},"parentId":101,"status":"0"},"deptId":105,"email":"ry@qq.com","loginDate":"2023-09-18 10:20:15","loginIp":"127.0.0.1","nickName":"瀚高","params":{},"phonenumber":"15666666666","postIds":[2],"remark":"测试员","roleIds":[2],"roles":[{"admin":false,"dataScope":"2","deptCheckStrictly":false,"flag":false,"menuCheckStrictly":false,"params":{},"roleId":2,"roleKey":"common","roleName":"普通角色","roleSort":2,"status":"0"}],"sex":"1","status":"0","updateBy":"admin","userId":2,"userName":"ry"}', '{"msg":"操作成功","code":200}', 0, NULL, '2023-09-18 13:22:56.09386', 38);
INSERT INTO ruoyi.sys_oper_log VALUES (2, '用户管理', 2, 'com.ruoyi.web.controller.system.SysUserController.edit()', 'PUT', 1, 'admin', NULL, '/system/user', '192.168.52.1', '内网IP', '{"admin":true,"avatar":"","createBy":"admin","createTime":"2023-09-18 10:20:15","delFlag":"0","dept":{"ancestors":"0,100,101","children":[],"deptId":103,"deptName":"研发部门","leader":"若依","orderNum":1,"params":{},"parentId":101,"status":"0"},"deptId":103,"email":"ry@163.com","loginDate":"2023-09-18 13:13:26.304","loginIp":"192.168.52.1","nickName":"瀚高管理员","params":{},"phonenumber":"15888888888","postIds":[1],"remark":"管理员","roleIds":[1],"roles":[{"admin":true,"dataScope":"1","deptCheckStrictly":false,"flag":false,"menuCheckStrictly":false,"params":{},"roleId":1,"roleKey":"admin","roleName":"超级管理员","roleSort":1,"status":"0"}],"sex":"1","status":"0","userId":1,"userName":"admin"}', NULL, 1, '不允许操作超级管理员用户', '2023-09-18 13:23:31.195066', 2);
INSERT INTO ruoyi.sys_oper_log VALUES (3, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', NULL, '/tool/gen/importTable', '192.168.52.1', '内网IP', '{"tables":"t1"}', '{"msg":"操作成功","code":200}', 0, NULL, '2023-09-18 13:28:04.865675', 36);
INSERT INTO ruoyi.sys_oper_log VALUES (4, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.synchDb()', 'GET', 1, 'admin', NULL, '/tool/gen/synchDb/t1', '192.168.52.1', '内网IP', '{}', '{"msg":"操作成功","code":200}', 0, NULL, '2023-09-18 13:28:20.35031', 29);
INSERT INTO ruoyi.sys_oper_log VALUES (5, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '192.168.52.1', '内网IP', '{"tables":"t1"}', NULL, 0, NULL, '2023-09-18 13:28:25.22628', 43);
INSERT INTO ruoyi.sys_oper_log VALUES (6, '定时任务', 2, 'com.ruoyi.quartz.controller.SysJobController.changeStatus()', 'PUT', 1, 'admin', NULL, '/monitor/job/changeStatus', '192.168.52.1', '内网IP', '{"jobId":2,"misfirePolicy":"0","params":{},"status":"0"}', '{"msg":"操作成功","code":200}', 0, NULL, '2023-09-18 13:29:07.143218', 22);
INSERT INTO ruoyi.sys_oper_log VALUES (7, '定时任务', 2, 'com.ruoyi.quartz.controller.SysJobController.changeStatus()', 'PUT', 1, 'admin', NULL, '/monitor/job/changeStatus', '192.168.52.1', '内网IP', '{"jobId":2,"misfirePolicy":"0","params":{},"status":"1"}', '{"msg":"操作成功","code":200}', 0, NULL, '2023-09-18 13:29:09.880819', 13);
INSERT INTO ruoyi.sys_oper_log VALUES (8, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '192.168.52.1', '内网IP', '{"tables":"t1"}', NULL, 0, NULL, '2023-09-18 13:51:35.509921', 157);
INSERT INTO ruoyi.sys_oper_log VALUES (9, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', NULL, '/tool/gen/importTable', '192.168.52.1', '内网IP', '{"tables":"test"}', '{"msg":"操作成功","code":200}', 0, NULL, '2023-09-18 13:51:55.405117', 47);
INSERT INTO ruoyi.sys_oper_log VALUES (10, '代码生成', 8, 'com.ruoyi.generator.controller.GenController.batchGenCode()', 'GET', 1, 'admin', NULL, '/tool/gen/batchGenCode', '192.168.52.1', '内网IP', '{"tables":"test"}', NULL, 0, NULL, '2023-09-18 13:52:09.192793', 43);
INSERT INTO ruoyi.sys_oper_log VALUES (11, '代码生成', 3, 'com.ruoyi.generator.controller.GenController.remove()', 'DELETE', 1, 'admin', NULL, '/tool/gen/2', '192.168.52.1', '内网IP', '{}', '{"msg":"操作成功","code":200}', 0, NULL, '2023-09-18 13:55:27.915676', 37);
INSERT INTO ruoyi.sys_oper_log VALUES (12, '代码生成', 6, 'com.ruoyi.generator.controller.GenController.importTableSave()', 'POST', 1, 'admin', NULL, '/tool/gen/importTable', '192.168.52.1', '内网IP', '{"tables":"part_2011"}', '{"msg":"操作成功","code":200}', 0, NULL, '2023-09-18 13:55:46.107925', 97);
INSERT INTO ruoyi.sys_oper_log VALUES (13, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.synchDb()', 'GET', 1, 'admin', NULL, '/tool/gen/synchDb/t1', '192.168.52.1', '内网IP', '{}', '{"msg":"操作成功","code":200}', 0, NULL, '2023-09-18 13:56:06.210539', 41);
INSERT INTO ruoyi.sys_oper_log VALUES (14, '代码生成', 2, 'com.ruoyi.generator.controller.GenController.editSave()', 'PUT', 1, 'admin', NULL, '/tool/gen', '192.168.52.1', '内网IP', '{"businessName":"t1","className":"T1","columns":[{"capJavaField":"Id","columnComment":"序号","columnId":1,"columnName":"id","columnType":"integer","createBy":"admin","createTime":"2023-09-18 13:28:04","dictType":"","edit":false,"htmlType":"input","increment":false,"insert":true,"isIncrement":"0","isInsert":"1","isPk":"0","isRequired":"0","javaField":"id","javaType":"Long","list":false,"params":{},"pk":false,"query":false,"queryType":"EQ","required":false,"sort":1,"superColumn":false,"tableId":1,"updateBy":"","updateTime":"2023-09-18 13:56:06","usableColumn":false},{"capJavaField":"Name","columnComment":"人员名称","columnId":2,"columnName":"name","columnType":"character varying","createBy":"admin","createTime":"2023-09-18 13:28:04","dictType":"","edit":true,"increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"0","javaField":"name","javaType":"String","list":true,"params":{},"pk":false,"query":true,"queryType":"LIKE","required":false,"sort":2,"superColumn":false,"tableId":1,"updateBy":"","updateTime":"2023-09-18 13:56:06","usableColumn":false}],"crud":true,"functionAuthor":"ruoyi","functionName":"测试","genPath":"/","genType":"0","moduleName":"system","options":"{}","packageName":"com.ruoyi.system","params":{},"sub":false,"tableComment":"测试表","tableId":1,"tableName":"t1","tplCategory":"crud","tree":false}', '{"msg":"操作成功","code":200}', 0, NULL, '2023-09-18 13:59:32.553318', 27);
INSERT INTO ruoyi.sys_oper_log VALUES (15, '用户头像', 2, 'com.ruoyi.web.controller.system.SysProfileController.avatar()', 'POST', 1, 'admin', NULL, '/system/user/profile/avatar', '192.168.52.1', '内网IP', '', '{"msg":"操作成功","imgUrl":"/profile/avatar/2023/09/18/blob_20230918140801A001.png","code":200}', 0, NULL, '2023-09-18 14:08:01.906978', 147);
INSERT INTO ruoyi.sys_oper_log VALUES (16, '个人信息', 2, 'com.ruoyi.web.controller.system.SysProfileController.updateProfile()', 'PUT', 1, 'admin', NULL, '/system/user/profile', '192.168.52.1', '内网IP', '{"admin":true,"avatar":"","createBy":"admin","createTime":"2023-09-18 10:20:15","delFlag":"0","dept":{"ancestors":"0,100,101","children":[],"deptId":103,"deptName":"研发部门","leader":"若依","orderNum":1,"params":{"@type":"java.util.HashMap"},"parentId":101,"status":"0"},"deptId":103,"email":"hgdb@highgo.com","loginDate":"2023-09-18 13:12:03.068","loginIp":"127.0.0.1","nickName":"瀚高","params":{"@type":"java.util.HashMap"},"phonenumber":"18888888888","remark":"管理员","roles":[{"admin":true,"dataScope":"1","deptCheckStrictly":false,"flag":false,"menuCheckStrictly":false,"params":{"@type":"java.util.HashMap"},"roleId":1,"roleKey":"admin","roleName":"超级管理员","roleSort":1,"status":"0"}],"sex":"0","status":"0","userId":1,"userName":"admin"}', '{"msg":"操作成功","code":200}', 0, NULL, '2023-09-18 14:08:43.375244', 21);
INSERT INTO ruoyi.sys_oper_log VALUES (17, '个人信息', 2, 'com.ruoyi.web.controller.system.SysProfileController.updateProfile()', 'PUT', 1, 'admin', NULL, '/system/user/profile', '192.168.52.1', '内网IP', '{"admin":true,"avatar":"","createBy":"admin","createTime":"2023-09-18 10:20:15","delFlag":"0","dept":{"ancestors":"0,100,101","children":[],"deptId":103,"deptName":"研发部门","leader":"若依","orderNum":1,"params":{"@type":"java.util.HashMap"},"parentId":101,"status":"0"},"deptId":103,"email":"hgdb@highgo.com","loginDate":"2023-09-18 13:12:03.068","loginIp":"127.0.0.1","nickName":"瀚高","params":{"@type":"java.util.HashMap"},"phonenumber":"18888888888","remark":"管理员","roles":[{"admin":true,"dataScope":"1","deptCheckStrictly":false,"flag":false,"menuCheckStrictly":false,"params":{"@type":"java.util.HashMap"},"roleId":1,"roleKey":"admin","roleName":"超级管理员","roleSort":1,"status":"0"}],"sex":"0","status":"0","userId":1,"userName":"admin"}', '{"msg":"操作成功","code":200}', 0, NULL, '2023-09-18 14:08:47.144172', 16);


--
-- TOC entry 4256 (class 0 OID 131864)
-- Dependencies: 344
-- Data for Name: sys_post; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.sys_post VALUES (1, 'ceo', '董事长', 1, '0', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_post VALUES (2, 'se', '项目经理', 2, '0', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_post VALUES (3, 'hr', '人力资源', 3, '0', 'admin', '2023-09-18 10:20:15', '', NULL, '');
INSERT INTO ruoyi.sys_post VALUES (4, 'user', '普通员工', 4, '0', 'admin', '2023-09-18 10:20:15', '', NULL, '');


--
-- TOC entry 4249 (class 0 OID 131802)
-- Dependencies: 337
-- Data for Name: sys_role; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.sys_role VALUES (1, '超级管理员', 'admin', 1, '1', 1, 1, '0', '0', 'admin', '2023-09-18 10:20:15', '', NULL, '超级管理员');
INSERT INTO ruoyi.sys_role VALUES (2, '普通角色', 'common', 2, '2', 1, 1, '0', '0', 'admin', '2023-09-18 10:20:15', '', NULL, '普通角色');


--
-- TOC entry 4250 (class 0 OID 131814)
-- Dependencies: 338
-- Data for Name: sys_role_dept; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.sys_role_dept VALUES (2, 100);
INSERT INTO ruoyi.sys_role_dept VALUES (2, 101);
INSERT INTO ruoyi.sys_role_dept VALUES (2, 105);


--
-- TOC entry 4253 (class 0 OID 131839)
-- Dependencies: 341
-- Data for Name: sys_role_menu; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.sys_role_menu VALUES (2, 1);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 2);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 3);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 4);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 100);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 101);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 102);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 103);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 104);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 105);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 106);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 107);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 108);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 109);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 110);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 111);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 112);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 113);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 114);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 115);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 116);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 117);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 500);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 501);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1000);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1001);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1002);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1003);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1004);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1005);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1006);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1007);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1008);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1009);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1010);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1011);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1012);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1013);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1014);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1015);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1016);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1017);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1018);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1019);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1020);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1021);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1022);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1023);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1024);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1025);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1026);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1027);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1028);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1029);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1030);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1031);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1032);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1033);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1034);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1035);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1036);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1037);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1038);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1039);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1040);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1041);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1042);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1043);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1044);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1045);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1046);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1047);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1048);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1049);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1050);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1051);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1052);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1053);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1054);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1055);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1056);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1057);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1058);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1059);
INSERT INTO ruoyi.sys_role_menu VALUES (2, 1060);


--
-- TOC entry 4252 (class 0 OID 131838)
-- Dependencies: 340
-- Data for Name: sys_user; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.sys_user VALUES (2, 105, 'ry', '瀚高', '00', 'ry@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', '2023-09-18 10:20:15', 'admin', '2023-09-18 10:20:15', 'admin', '2023-09-18 13:22:56.025865', '测试员');
INSERT INTO ruoyi.sys_user VALUES (1, 103, 'admin', '瀚高', '00', 'hgdb@highgo.com', '18888888888', '0', '/profile/avatar/2023/09/18/blob_20230918140801A001.png', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', '2023-09-18 13:12:03.068', 'admin', '2023-09-18 10:20:15', '', '2023-09-18 14:08:47.122363', '管理员');


--
-- TOC entry 4255 (class 0 OID 131859)
-- Dependencies: 343
-- Data for Name: sys_user_post; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.sys_user_post VALUES (1, 1);
INSERT INTO ruoyi.sys_user_post VALUES (2, 2);


--
-- TOC entry 4254 (class 0 OID 131858)
-- Dependencies: 342
-- Data for Name: sys_user_role; Type: TABLE DATA; Schema: ruoyi; Owner: highgo
--

INSERT INTO ruoyi.sys_user_role VALUES (1, 1);
INSERT INTO ruoyi.sys_user_role VALUES (2, 2);


--
-- TOC entry 4572 (class 0 OID 0)
-- Dependencies: 346
-- Name: seq_gen_table_column_column_id; Type: SEQUENCE SET; Schema: ruoyi; Owner: highgo
--

SELECT pg_catalog.setval('ruoyi.seq_gen_table_column_column_id', 23, true);


--
-- TOC entry 4573 (class 0 OID 0)
-- Dependencies: 345
-- Name: seq_gen_table_table_id; Type: SEQUENCE SET; Schema: ruoyi; Owner: highgo
--

SELECT pg_catalog.setval('ruoyi.seq_gen_table_table_id', 3, true);


--
-- TOC entry 4574 (class 0 OID 0)
-- Dependencies: 349
-- Name: seq_sys_config_config_id; Type: SEQUENCE SET; Schema: ruoyi; Owner: highgo
--

SELECT pg_catalog.setval('ruoyi.seq_sys_config_config_id', 7, false);


--
-- TOC entry 4575 (class 0 OID 0)
-- Dependencies: 347
-- Name: seq_sys_dept_dept_id; Type: SEQUENCE SET; Schema: ruoyi; Owner: highgo
--

SELECT pg_catalog.setval('ruoyi.seq_sys_dept_dept_id', 110, false);


--
-- TOC entry 4576 (class 0 OID 0)
-- Dependencies: 348
-- Name: seq_sys_dict_data_dict_code; Type: SEQUENCE SET; Schema: ruoyi; Owner: highgo
--

SELECT pg_catalog.setval('ruoyi.seq_sys_dict_data_dict_code', 30, false);


--
-- TOC entry 4577 (class 0 OID 0)
-- Dependencies: 352
-- Name: seq_sys_dict_type_dict_id; Type: SEQUENCE SET; Schema: ruoyi; Owner: highgo
--

SELECT pg_catalog.setval('ruoyi.seq_sys_dict_type_dict_id', 11, false);


--
-- TOC entry 4578 (class 0 OID 0)
-- Dependencies: 350
-- Name: seq_sys_job_job_id; Type: SEQUENCE SET; Schema: ruoyi; Owner: highgo
--

SELECT pg_catalog.setval('ruoyi.seq_sys_job_job_id', 4, false);


--
-- TOC entry 4579 (class 0 OID 0)
-- Dependencies: 351
-- Name: seq_sys_job_log_job_log_id; Type: SEQUENCE SET; Schema: ruoyi; Owner: highgo
--

SELECT pg_catalog.setval('ruoyi.seq_sys_job_log_job_log_id', 1, false);


--
-- TOC entry 4580 (class 0 OID 0)
-- Dependencies: 353
-- Name: seq_sys_logininfor_info_id; Type: SEQUENCE SET; Schema: ruoyi; Owner: highgo
--

SELECT pg_catalog.setval('ruoyi.seq_sys_logininfor_info_id', 2, true);


--
-- TOC entry 4581 (class 0 OID 0)
-- Dependencies: 357
-- Name: seq_sys_menu_menu_id; Type: SEQUENCE SET; Schema: ruoyi; Owner: highgo
--

SELECT pg_catalog.setval('ruoyi.seq_sys_menu_menu_id', 1061, false);


--
-- TOC entry 4582 (class 0 OID 0)
-- Dependencies: 355
-- Name: seq_sys_notice_notice_id; Type: SEQUENCE SET; Schema: ruoyi; Owner: highgo
--

SELECT pg_catalog.setval('ruoyi.seq_sys_notice_notice_id', 3, false);


--
-- TOC entry 4583 (class 0 OID 0)
-- Dependencies: 354
-- Name: seq_sys_oper_log_oper_id; Type: SEQUENCE SET; Schema: ruoyi; Owner: highgo
--

SELECT pg_catalog.setval('ruoyi.seq_sys_oper_log_oper_id', 17, true);


--
-- TOC entry 4584 (class 0 OID 0)
-- Dependencies: 358
-- Name: seq_sys_post_post_id; Type: SEQUENCE SET; Schema: ruoyi; Owner: highgo
--

SELECT pg_catalog.setval('ruoyi.seq_sys_post_post_id', 5, false);


--
-- TOC entry 4585 (class 0 OID 0)
-- Dependencies: 356
-- Name: seq_sys_role_role_id; Type: SEQUENCE SET; Schema: ruoyi; Owner: highgo
--

SELECT pg_catalog.setval('ruoyi.seq_sys_role_role_id', 3, false);


--
-- TOC entry 4586 (class 0 OID 0)
-- Dependencies: 359
-- Name: seq_sys_user_user_id; Type: SEQUENCE SET; Schema: ruoyi; Owner: highgo
--

SELECT pg_catalog.setval('ruoyi.seq_sys_user_user_id', 3, false);


--
-- TOC entry 4013 (class 2606 OID 131893)
-- Name: gen_table_column gen_table_column_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.gen_table_column
    ADD CONSTRAINT gen_table_column_pkey PRIMARY KEY (column_id);


--
-- TOC entry 4009 (class 2606 OID 131888)
-- Name: gen_table gen_table_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.gen_table
    ADD CONSTRAINT gen_table_pkey PRIMARY KEY (table_id);


--
-- TOC entry 4003 (class 2606 OID 131902)
-- Name: qrtz_blob_triggers qrtz_blob_triggers_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.qrtz_blob_triggers
    ADD CONSTRAINT qrtz_blob_triggers_pkey PRIMARY KEY (sched_name, trigger_name, trigger_group);


--
-- TOC entry 3999 (class 2606 OID 131895)
-- Name: qrtz_calendars qrtz_calendars_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.qrtz_calendars
    ADD CONSTRAINT qrtz_calendars_pkey PRIMARY KEY (sched_name, calendar_name);


--
-- TOC entry 4017 (class 2606 OID 131910)
-- Name: qrtz_cron_triggers qrtz_cron_triggers_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.qrtz_cron_triggers
    ADD CONSTRAINT qrtz_cron_triggers_pkey PRIMARY KEY (sched_name, trigger_name, trigger_group);


--
-- TOC entry 4005 (class 2606 OID 131886)
-- Name: qrtz_fired_triggers qrtz_fired_triggers_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.qrtz_fired_triggers
    ADD CONSTRAINT qrtz_fired_triggers_pkey PRIMARY KEY (sched_name, entry_id);


--
-- TOC entry 4011 (class 2606 OID 131879)
-- Name: qrtz_job_details qrtz_job_details_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.qrtz_job_details
    ADD CONSTRAINT qrtz_job_details_pkey PRIMARY KEY (sched_name, job_name, job_group);


--
-- TOC entry 4001 (class 2606 OID 131881)
-- Name: qrtz_locks qrtz_locks_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.qrtz_locks
    ADD CONSTRAINT qrtz_locks_pkey PRIMARY KEY (sched_name, lock_name);


--
-- TOC entry 4007 (class 2606 OID 131885)
-- Name: qrtz_paused_trigger_grps qrtz_paused_trigger_grps_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.qrtz_paused_trigger_grps
    ADD CONSTRAINT qrtz_paused_trigger_grps_pkey PRIMARY KEY (sched_name, trigger_group);


--
-- TOC entry 4015 (class 2606 OID 131889)
-- Name: qrtz_scheduler_state qrtz_scheduler_state_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.qrtz_scheduler_state
    ADD CONSTRAINT qrtz_scheduler_state_pkey PRIMARY KEY (sched_name, instance_name);


--
-- TOC entry 4028 (class 2606 OID 131948)
-- Name: qrtz_simple_triggers qrtz_simple_triggers_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.qrtz_simple_triggers
    ADD CONSTRAINT qrtz_simple_triggers_pkey PRIMARY KEY (sched_name, trigger_name, trigger_group);


--
-- TOC entry 4024 (class 2606 OID 131922)
-- Name: qrtz_simprop_triggers qrtz_simprop_triggers_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.qrtz_simprop_triggers
    ADD CONSTRAINT qrtz_simprop_triggers_pkey PRIMARY KEY (sched_name, trigger_name, trigger_group);


--
-- TOC entry 4019 (class 2606 OID 131923)
-- Name: qrtz_triggers qrtz_triggers_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.qrtz_triggers
    ADD CONSTRAINT qrtz_triggers_pkey PRIMARY KEY (sched_name, trigger_name, trigger_group);


--
-- TOC entry 4022 (class 2606 OID 131917)
-- Name: sys_config sys_config_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_config
    ADD CONSTRAINT sys_config_pkey PRIMARY KEY (config_id);


--
-- TOC entry 4026 (class 2606 OID 131906)
-- Name: sys_dept sys_dept_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_dept
    ADD CONSTRAINT sys_dept_pkey PRIMARY KEY (dept_id);


--
-- TOC entry 4030 (class 2606 OID 131925)
-- Name: sys_dict_data sys_dict_data_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_dict_data
    ADD CONSTRAINT sys_dict_data_pkey PRIMARY KEY (dict_code);


--
-- TOC entry 4034 (class 2606 OID 131937)
-- Name: sys_dict_type sys_dict_type_dict_type; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_dict_type
    ADD CONSTRAINT sys_dict_type_dict_type UNIQUE (dict_type);


--
-- TOC entry 4036 (class 2606 OID 131965)
-- Name: sys_dict_type sys_dict_type_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_dict_type
    ADD CONSTRAINT sys_dict_type_pkey PRIMARY KEY (dict_id);


--
-- TOC entry 4038 (class 2606 OID 131946)
-- Name: sys_job_log sys_job_log_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_job_log
    ADD CONSTRAINT sys_job_log_pkey PRIMARY KEY (job_log_id);


--
-- TOC entry 4032 (class 2606 OID 131951)
-- Name: sys_job sys_job_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_job
    ADD CONSTRAINT sys_job_pkey PRIMARY KEY (job_id, job_name, job_group);


--
-- TOC entry 4040 (class 2606 OID 131961)
-- Name: sys_logininfor sys_logininfor_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_logininfor
    ADD CONSTRAINT sys_logininfor_pkey PRIMARY KEY (info_id);


--
-- TOC entry 4046 (class 2606 OID 131959)
-- Name: sys_menu sys_menu_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_menu
    ADD CONSTRAINT sys_menu_pkey PRIMARY KEY (menu_id);


--
-- TOC entry 4044 (class 2606 OID 131976)
-- Name: sys_notice sys_notice_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_notice
    ADD CONSTRAINT sys_notice_pkey PRIMARY KEY (notice_id);


--
-- TOC entry 4052 (class 2606 OID 131953)
-- Name: sys_oper_log sys_oper_log_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_oper_log
    ADD CONSTRAINT sys_oper_log_pkey PRIMARY KEY (oper_id);


--
-- TOC entry 4065 (class 2606 OID 131974)
-- Name: sys_post sys_post_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_post
    ADD CONSTRAINT sys_post_pkey PRIMARY KEY (post_id);


--
-- TOC entry 4050 (class 2606 OID 131956)
-- Name: sys_role_dept sys_role_dept_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_role_dept
    ADD CONSTRAINT sys_role_dept_pkey PRIMARY KEY (role_id, dept_id);


--
-- TOC entry 4059 (class 2606 OID 131967)
-- Name: sys_role_menu sys_role_menu_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_role_menu
    ADD CONSTRAINT sys_role_menu_pkey PRIMARY KEY (role_id, menu_id);


--
-- TOC entry 4048 (class 2606 OID 131957)
-- Name: sys_role sys_role_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_role
    ADD CONSTRAINT sys_role_pkey PRIMARY KEY (role_id);


--
-- TOC entry 4057 (class 2606 OID 131978)
-- Name: sys_user sys_user_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_user
    ADD CONSTRAINT sys_user_pkey PRIMARY KEY (user_id);


--
-- TOC entry 4063 (class 2606 OID 131972)
-- Name: sys_user_post sys_user_post_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_user_post
    ADD CONSTRAINT sys_user_post_pkey PRIMARY KEY (user_id, post_id);


--
-- TOC entry 4061 (class 2606 OID 131975)
-- Name: sys_user_role sys_user_role_pkey; Type: CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.sys_user_role
    ADD CONSTRAINT sys_user_role_pkey PRIMARY KEY (user_id, role_id);


--
-- TOC entry 4020 (class 1259 OID 131982)
-- Name: qrtz_triggerssched_name; Type: INDEX; Schema: ruoyi; Owner: highgo
--

CREATE INDEX qrtz_triggerssched_name ON ruoyi.qrtz_triggers USING btree (sched_name, job_name, job_group);


--
-- TOC entry 4041 (class 1259 OID 131983)
-- Name: sys_logininforidx_sys_logininfor_lt; Type: INDEX; Schema: ruoyi; Owner: highgo
--

CREATE INDEX sys_logininforidx_sys_logininfor_lt ON ruoyi.sys_logininfor USING btree (login_time);


--
-- TOC entry 4042 (class 1259 OID 131984)
-- Name: sys_logininforidx_sys_logininfor_s; Type: INDEX; Schema: ruoyi; Owner: highgo
--

CREATE INDEX sys_logininforidx_sys_logininfor_s ON ruoyi.sys_logininfor USING btree (status);


--
-- TOC entry 4053 (class 1259 OID 131979)
-- Name: sys_oper_logidx_sys_oper_log_bt; Type: INDEX; Schema: ruoyi; Owner: highgo
--

CREATE INDEX sys_oper_logidx_sys_oper_log_bt ON ruoyi.sys_oper_log USING btree (business_type);


--
-- TOC entry 4054 (class 1259 OID 131980)
-- Name: sys_oper_logidx_sys_oper_log_ot; Type: INDEX; Schema: ruoyi; Owner: highgo
--

CREATE INDEX sys_oper_logidx_sys_oper_log_ot ON ruoyi.sys_oper_log USING btree (oper_time);


--
-- TOC entry 4055 (class 1259 OID 131981)
-- Name: sys_oper_logidx_sys_oper_log_s; Type: INDEX; Schema: ruoyi; Owner: highgo
--

CREATE INDEX sys_oper_logidx_sys_oper_log_s ON ruoyi.sys_oper_log USING btree (status);


--
-- TOC entry 4066 (class 2606 OID 131987)
-- Name: qrtz_blob_triggers qrtz_blob_triggers_ibfk_1; Type: FK CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.qrtz_blob_triggers
    ADD CONSTRAINT qrtz_blob_triggers_ibfk_1 FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES ruoyi.qrtz_triggers(sched_name, trigger_name, trigger_group);


--
-- TOC entry 4067 (class 2606 OID 131992)
-- Name: qrtz_cron_triggers qrtz_cron_triggers_ibfk_1; Type: FK CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.qrtz_cron_triggers
    ADD CONSTRAINT qrtz_cron_triggers_ibfk_1 FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES ruoyi.qrtz_triggers(sched_name, trigger_name, trigger_group);


--
-- TOC entry 4070 (class 2606 OID 132007)
-- Name: qrtz_simple_triggers qrtz_simple_triggers_ibfk_1; Type: FK CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.qrtz_simple_triggers
    ADD CONSTRAINT qrtz_simple_triggers_ibfk_1 FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES ruoyi.qrtz_triggers(sched_name, trigger_name, trigger_group);


--
-- TOC entry 4069 (class 2606 OID 132002)
-- Name: qrtz_simprop_triggers qrtz_simprop_triggers_ibfk_1; Type: FK CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.qrtz_simprop_triggers
    ADD CONSTRAINT qrtz_simprop_triggers_ibfk_1 FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES ruoyi.qrtz_triggers(sched_name, trigger_name, trigger_group);


--
-- TOC entry 4068 (class 2606 OID 131997)
-- Name: qrtz_triggers qrtz_triggers_ibfk_1; Type: FK CONSTRAINT; Schema: ruoyi; Owner: highgo
--

ALTER TABLE ONLY ruoyi.qrtz_triggers
    ADD CONSTRAINT qrtz_triggers_ibfk_1 FOREIGN KEY (sched_name, job_name, job_group) REFERENCES ruoyi.qrtz_job_details(sched_name, job_name, job_group);


-- Completed on 2023-09-18 14:09:28

--
-- PostgreSQL database dump complete
--

